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.
N4538FLohse Teal K · Cordova, AKN4538GAarow Aircraft Leasing LLC · Mcminnville, ORN4538NN4538n LLC · Spring Lake, MIN4538QFlying V LLC · West Berlin, NJN4538TLarsen Jeffrey A · Spokane Valley, WAN4538XHicks Paul · Greenfield Center, NYN4538YKnutson Wayne R · Thompson, NDFirst renewal noticeN4539ASvenningsen Joshua J · Menomonie, WIN4539LTempin Alan Martyn · Woodstock, ILN4539PMolnar William J · Janesville, WIN4539SMask Rickey D · Denison, TXN4539VMinto Victoria L · Omak, WAN4539WWjordan & Co LLC · New Fairfield, CTN4539X4539x LLC · Saint John, INN453BBBass Equipment LLC · Texarkana, ARN453CMUniversity Of Central Missouri · Warrensburg, MON453DBAguirre-Y-Luker Grant Climaco · Guthrie, OKN453EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN453HCRegistration Pending · Wasilla, AKRegistration pendingN453HZBerger Michael B · Washington Island, WIN453KBPashkevich Michele · Pine Bluff, ARN453KCBryant Brothers Aviation LLC · Saint Marys, OHN453LPFrsp LLC · Watkins, CON453MCMcneil Kenneth A · Fort Meade, FLN453MFSpain William D Jr · Mahopac, NYN453MKNorth Star Aviation · Mankato, MNN453PTHenrie Aviation LLC · Fairfield, NJN453SAHts LLC · Hudsonville, MIN453SPUnited States Air Force Owner · Elmendorf Afb, AKN453TCCarrero Ian J · Memphis, TNN453WMAerostar Companies Inc · Dover, DEFirst renewal noticeN453YRPatterson John III · West Chester, OHN4540Mathis Mark L · Fremont, CAN45406Tweten Scott D · Healdsburg, CAN45409Blair Dorothy A · Saginaw, MIN4540JDreyer Richard F · Springdale, ARN4540PKahn Stephen G · Morton, PAN4540RCase Herbert P · Wendell, NCN4540STdc Aviation LLC · Wilmington, DEN4540TMurray Clifford K · Brunswick, GAN45412Diesel Aviation LLC · Millbrook, ALN4541ASteward David F · Bartlett, TNN4541RBaker William D · Hyannis, NEN4541TUniversal Technical Institute Inc · Miramar, FLN4541XPeachtree Air LLC · Wilmington, DEN4542BWilliamson Charles F · Ocean Isle Beach, NCN4542JUht Christian M · Greenville, NYN4542LTabooma Flyers Inc · Vancouver, WAN4542NPollack Richard D · Santa Monica, CAN4542RBlue Skies Flying Club LLC · Painesville, OH
Back to AD 2007-04-19 R1