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.
N53147Cloud Cappers Flying Club Inc · Salisbury, NCN5314E57d Flyers LLC · Shelby Township, MIN5314KLaporte Aviation Services Inc · La Porte, INN5314LGormley Laurie A · Las Cruces, NMN5314PStaiger John L III · Saint Clair, MIN5314RDelta State University · Cleveland, MSN5314VBurke Sterling M · Olympia Fields, ILN5314WRasler Christopher · Puyallup, WAN5314XMoody Bible Institute Of Chicago · Spokane, WAN5315BBrady Brian O · Kirkland, WAN5315LTorres Daniel A · Baldwin, NYN5315PChrystal Bluebird LLC · Valley Center, KSN5315XAtarah LLC · Tucson, AZN5316DErickson Todd E · Wasilla, AKN5316ENoble Zachary Q · Rhoadesville, VAN5316JCocola Gary M · Fresno, CAN5316PBrooks D Craig · Menifee, CAN5316RTraining Planes LLC · Tampa, FLN5316SDk Air LLC · Brookings, ORN5317ABlue Skies Air LLC · Allen, TXN5317BWilson Bach M · Piedmont, SCN5317DMonroe City Aviators LLC · Palmyra, MON5317ECallaghan James J III · West Chester, PAN5317HHottel Cessna LLC · Prescott, AZN5317KN5317k Corp Trustee · Wilmington, DEN5317NJones Timothy S · St Simons Is, GAN5317RHayton James B · Sedro Woolley, WAN5317TCovert Charles F · The Dalles, ORN5317WUnterbach Mark J · Discovery Bay, CAN5317YBaker Avery R · Bonifay, FLN53182Wardlaw James C · Albuquerque, NMN53183Allred Gina D Administrator · Centre, ALN53187Salomon William · Woodstock, NYN53189Naylor Irvin H Jr · Charlotte, NCN5318ABuchanan Harvey · Townsend, MAN5318DBolton Frederick J · Willow, AKN5318EBishops Ltd · Virginia Beach, VAN5318GBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN5318LWing Timothy R · Raleigh, NCN5318TSmith Stephan R · Morrisville, PAN5318VTyson Ron A · Fredericksburg, TXN5319BMcpherson Russell H · Forest Lake, MNN5319DCoachron Investments LLC · Grosse Ile, MIN5319EKing Mark B · Lewisville, TXN5319SCampo Jonathan Ibarra · Lakeland, FLN5319XMeadowlake Aviation LLC · Lenoir City, TNN531ABMissionair Inc · Danbury, CTN531ACCulwell Michael Fredrick · Vestavia Hills, ALN531ALClark Terry W · Palmer, AKN531AMLippert Michael Thomas · California, MD
Back to AD 2007-04-19 R1