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.
N3614XPanther Enterprises LLC · Fort Myers, FLN3614YEmission -Air Inc · Lexington, NCN36150Bas Part Sales LLC · Greeley, CON3615CMarkwardt Jacquelyn K · Santa Cruz, CAN3615MRenfro Michael W · Bethel, AKN3615NWalker Eric L · Southlake, TXN3615QPlane Safe Aircraft Maintenance Inc · Waukesha, WIN36167James Brett · Louisburg, NCN3616DRobinson Mark V · Vacaville, CAFirst renewal noticeN3616NDe Masters Jasper · Bakersfield, CAN3616PKidd Myles · Machesney Park, ILN3616UHatch Koay A · Gilbert, AZN3616YAnderson Dana R · Redding, CAN36173Schuster Darin D · New Castle, DEN36176Otte Duane P · Plainfield, INN36178California Flyers Training Solutions LLC · Sun City, CAN3617PPhilpott Gary D · Camden, SCN3617YSchindele Micheal D · Tolna, NDN36185Stapleton Rita · Gallipolis, OHN36187Swaz Aviation LLC · Mesa, AZN3618CHoshor Matthew David · Wetumpka, ALN3618GIndustrial Consulting LLC · Repton, ALN3618MRatcliffe Andrew M · Jerome, AZN3618NYoung Donald Colin · West Plains, MON3618XHildenbrand Casey E · Circleville, OHN36194Cripps Alan Stephen · Hoover, ALN3619CHamby Michael R · Parma, IDN3619JFisher Ag Service LLC · Cardington, OHN3619KKirk Trevor A · Ponderay, IDN3619NChiques Aero Corporation · Lancaster, PAN3619RBachelor Cabin Flying Services Inc · Kokomo, INN3619XNeeds Shaely M · Pueblo, CON3619YWilliams Jimmy Z · Sherman, TXN361ACBond Robert E · Kingsville, MON361AHHodge Cleophas U · St Thomas, VIN361AKAronson Kenneth I Trustee · Truckee, CAN361CPBarr Air Patrol LLC · Mesquite, TXN361CWCk Aviation LLC · Brookhaven, MSN361DNeill James H · Keller, TXN361DBLcb Leasing · Manassas, VAFirst renewal noticeN361DMLeibstein Guy · Babylon, NYN361ESGrady Paul D · Reno, NVN361ETW Fairfield Aviation Inc · Caldwell, KSN361FSBlue Yonder Aviation Inc · Rochester, NYN361GAGlidewell Aviation Inc · Parkland, FLN361GCFff Leasing LLC · Dover, DEN361JBCarroll Farm Management Company · Carthage, ILN361JFFuller James K · Goliad, TXN361KWFliteco Holdings LLC · Lewes, DEN361LRegistered aircraft
Back to AD 2007-04-19 R1