AD 85-01-01
Registered aircraft · 317
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:85-01-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-01-01')
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:85-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:85-01-01') 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.
N708DGBravan Aviation · Fort Lauderdale, FLN70FEBrpemm Investments LLC · Lincoln, NEN711BN711bn LLC · Miami, FLN711KPAmerican Boiler Services Inc · Saint Louis, MON711REMontana Aircraft Trust Inc Trustee · Bozeman, MTN717JGHvl Air · Fresno, CAN717XBanana Hill LLC · Ashland, ORN719PBGraber Joel · Collins, MSN71KACentral Virginia Aviation Inc · North Dinwiddie, VAN720COscar Charlie LLC · California, MDN722VBCopacetic Air LLC · Rutledge, TNN7230HAb Aviation LLC · Johns Island, SCN725ARTrr Land & Livestock LLC · Douglas, WYN735KSouth Seattle Community College · Seattle, WAN73MCCoastal Helicopters LLC · La Verne, CAN73PHBronson Air LLC · Thebes, ILN74JVAdvanced Avionics LLC · Cookeville, TNN750RCLuke & Payton LLC · Marianna, ARN751KCJ A Peterson Enterprises Inc · Shawnee Mission, KSN754TWCentral Virginia Aviation Inc · North Dinwiddie, VAN757BAWw Air LLC · Burwell, NEN758KCentral Virginia Aviation Inc · North Dinwiddie, VAN75RSCentral Virginia Aviation Inc · North Dinwiddie, VAN761KCentral Virginia Aviation Inc · Petersburg, VAN767MCMonument Aviation LLC · North Chesterfield, VAN76GMDodson International Parts Inc · Rantoul, KSN771PADodson International Parts Inc · Rantoul, KSN773PWTexair LLC · Hereford, TXN775DMGeneration Jets LLC · Denison, TXN776LDodson International Parts Inc · Rantoul, KSN777EB7eb Aviation LLC · Dallas, TXN77HEDavis Aviation Inc · Brandon, MSN77NBDodson International Parts Inc · Rantoul, KSN77PFAerospace Asset Holdings LLC · Wilmington, DEFirst renewal noticeN77WMWhiskey Mike Aero LLC · Wilmington, DEN781AKAlsworth Glen Sr · Port Alsworth, AKN787TTMjw Aviation LLC · Beaumont, TXN790AWilliam C New Aviation Services LLC · Morgan City, LAN7931DJet Air Inc · Galesburg, ILN797CFAmerican Aviation Inc · Brooksville, FLN799DDRenfro Michael W · Bethel, AKN799GKCentral Virginia Aviation Inc · North Dinwiddie, VAN808SWFmgi Inc · Woodstock, GAN811KCTwa International Inc · Cheyenne, WYFirst renewal noticeN812ACInternational Air Services Inc Trustee · Carson City, NVN813JBDodson International Parts Inc · Rantoul, KSN821VVElite Team Offices Inc · Clovis, CAN825SDGreat Valley Management Inc · New Castle, DEN82XPJones Harry R Jr · Houston, TXN83TCDel Mar College · Corpus Christi, TX
Back to AD 85-01-01