AD 80-06-05
Registered aircraft · 121,051
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:80-06-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-06-05')
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:80-06-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-06-05') 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.
N1006ESpot-Air LLC · Burlington, TXN1006QMills James A · Dearborn, MIN1006UFike Brian Arthur · Florissant, CON10070Red Dog LLC · Sicklerville, NJN10072Czupich Holly Nicole · Maumee, OHN10073Brown Charles A · Boise, IDN10075Gausman Grace K · Lompoc, CAN10076Gamm Stephen Wade · Warrenton, VAN10077Caudle John Edwin II · Arlington, TXN1007CVee Two Inc · Merritt Island, FLN1007F007 Aviation LLC · Wilmington, DEN1007PSimpson Tad M · Decatur, ILN1007THollar Larry · Winston Salem, NCN10082Go Leasing Company · Phillipsburg, KSN10085Souza Samuel J · Gainesville, GAN10086Motley Steven A · Winter Garden, FLN10089Saucier Anthony J · La Mesa, CAN1008AAerial Surveys International LLC · Watkins, CON1008CBat Flying LLC · Blue Earth, MNN1008EEdwards Gregory S · Guthrie, OKN1008KAu Jerry · Manhattan Beach, CAN1008MHottenstein William R · Kingston, PAN1008XSmith Dan V · Anchorage, AKN10092Steckowski Stephan O · Eastman, GAN10096Elite Fleet Jacksonville LLC · Jacksonville, FLN10098Hobbs Adam C · Monroe, WAN1009AWilliams Wendell · Anchorage, AKN1009EAven Michael D · Georgetown, INN1009PFerrier William T · Woodland, CAN1009QWatson James E Jr · Victor, CON1009XEnders Richard A · San Bernardino, CAN100ANWatson Family Investments LLC · Houston, TXN100AWDe La Torre Alfonso Jr · Brownsville, TXN100BMarshall Xavier T · Carson, CAN100BHChopper Aviation LLC · Cahokia Heights, ILN100BUJav Aviation LLC · Landenberg, PAN100BVHoward Keith · Fayetteville, NCN100CAFass Flyers LLC · Garden Ridge, TXN100CDVenhaus Randy J · Cordova, TNN100CGGreene Carol W · Mahwah, NJN100CRFreudenberg Joseph B · Almira, WAN100CWCoffin Craig T · Glendale, CAN100CXCs Leasing LLC · Rockville, MDN100DBState Of Wisconsin · Madison, WIN100DFFisher Charlton Dru · Houston, TXN100DPEskind Thomas O Jr · Dallas, TXN100DRWolfe Stephen Charles · Tulsa, OKN100DVHarvey Donald W · Concord, NCN100DZSkydive Santa Barbara LLC · Lompoc, CAN100FAAlmost Heaven Aviation LLC · Morgantown, WV
Back to AD 80-06-05