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.
N3250YEonm182 LLC · El Paso, TXN3250ZLawrence Grant Heath · Saratoga Springs, UTN32514Summit Flight Academy LLC · Peculiar, MON32518Lahmann Jason L · Tripoli, IAN32519Bachert Nicholas T · California, MDN3251ABrews LLC · Homer, AKN3251DE S P Aviation LLC · Wilmington, DEN3251FRegistered aircraftN3251WCorporate Flight Mangement LLC · Dallas, TXN3251YCarlson Andrew J · Ashville, NYN3251ZCopper River Airmotive LLC · Copper Center, AKN32521Proflite Of Alaska LLC · Fairbanks, AKN32524Barth Tom L · Manhattan, KSN32525Willaford Gina T · Cape Coral, FLN32526Cannon Adam H · Purcell, OKN3252DQuigg Aircraft LLC · Muskegon, MIN3252FBubes Michael D · Cocoa, FLN3252JBas Part Sales LLC · Greeley, CON3252PGodbout Kevin P · South Hadley, MAN3252QArcher Inc · South Ozone Park, NYN3252REllis Eric Lee Trustee · Lincoln, CAN3252SWhite Robert E · Woodlawn, TNN3252TFugfugosh Mahdi A · Castro Valley, CAN32531Greenville Flight LLC · Greer, SCN32534Bh534 LLC · West Hartford, CTN32539Orosz Ryan · Santa Clara, CAN3253SCobb Darrell V · Corsicana, TXN32540Registration Pending · Mocksville, NCRegistration pendingN32542Jordening Kim L · Fairbury, NEN32543Echo 7 Tango Aviation LLC · Pottsboro, TXN32544Swaz Aviation LLC · Mesa, AZN32548Pray Aviation Inc · Augusta, KSN3254GEdling Tyrell R · The Dalles, ORN3254SAllen John C · Austerlitz, NYN3254UWright Ronald J · Olympia, WAN3254WKelley James · Mena, ARN32550Minto Daniel Warren · Wake Forest, NCN32551Gcbc LLC · Norman, OKN32552Garys Fork Auto Service LLC · Hydes, MDN32553Lathan Stefan · Monrovia, INN32556Mcguire Richard L · Valparaiso, INN32559Eagle Valley Aviation LLC · Howard, PAN3255FThomas Clayton · Culleoka, TNN3255GSmith Julian Scott · Arlington, TXN3255HAlba Leasing Services LLC · Scottsdale, AZN3255WPridmore Joseph P · Columbus, MSN3255ZBabin Joseph J · Fairbanks, AKN32560Burchell Wade C · Chalfont, PAN32565Cb Aviation Inc · Ogden, UTN32566Mob Aviation USA LLC · Auburndale, FL
Back to AD 2007-04-19 R1