AD 2007-04-19 R1
Registered aircraft · 108,434
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N4257JBroderick Randolph W · Shelby, OHN4257ST&S Proch Investments LLC · Harrisonville, MON4257ZSmith April A · Anchorage, AKN42580Cox Bruce R · Brock, TXN42589Haas Kile B · Monette, ARN4258CSonrise Aviation LLC · Portland, INN4258HCeason Jeffrey M · Tucson, AZN4258JAlpha Kilo Aviation LLC · Wasilla, AKN42591Mcferrin Clinton J · Kyle, TXN42594Wunsch Larry K · Fond Du Lac, WIN42599Avco Patrol LLC · Lyndon, KSN4259PSkypark Inc · Wadsworth, OHN425ADoberenz Marvin E · Granbury, TXN425AADoyle Jimmy Dan · Christoval, TXN425AJSomnium Consulting Services LLC · Pensacola, FLN425AKCuddy Gretchen H · Anchorage, AKFirst renewal noticeN425BBGarcia Robert Lee · Horseshoe Bay, TXN425BCRegistered aircraftN425BZMcgrath Robert J · Simpsonville, SCN425CBSummit Flight Academy LLC · Peculiar, MON425CDDtn Aviation LLC · Winona, MNN425CHKeeton Farms LLC · Monticello, KYN425CPCivil Air Patrol Inc · Maxwell Afb, ALN425CRAtp Aircraft 8 LLC · Wilmington, DEN425DBWings Over Texas Holdings LLC · Denton, TXN425DLTotal Flight Aircraft Leasing LLC · Apex, NCN425DPKuhn Alexander G · Fairfield, CTN425EJCity Of Portland · Portland, ORN425FLFrogtown Investments LLC · Owensboro, KYN425FPUtah State University · Logan, UTN425HACci Air LLC · Albion, MIN425JMccracken Lester G · Edinboro, PAN425JVBarnes Timothy K · Chapel Hill, NCN425KAHerrmann Laura Jean Trustee · Saint Bonifacius, MNN425KTBartley Terrence E · Port Orange, FLN425KWWooten Kurt R · Wichita, KSN425MBPauls Valley Fly Boys LLC · Davis, OKN425MGGrinnan Michael · Stafford, VAN425MSMcdonald Shane · Belmont, MSN425NM425nm Inc · Denver, CON425PQuimus Aviation LLC · Townsend, WIN425PABas Part Sales LLC · Greeley, CON425PKGood Flight LLC · San Luis Obispo, CAN425PRHorizon Technical Services Inc · Farmingdale, NYN425RHelmkamp Janet K · Bethalto, ILN425RBAkguc Cengiz · Lantana, TXN425RKQualitair LLC · MichelstadtN425RTN425rt LLC · Kalispell, MTN425RVRegistered aircraftN425RWQualitair LLC Trustee · Michelstadt
Back to AD 2007-04-19 R1