AD 97-25-01
Registered aircraft · 3,184
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:97-25-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:97-25-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:97-25-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:97-25-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.
N116NDepartment Of Homeland Security · Washington, DCN116TXPlacid Air LLC · Naples, FLN117CWestern Enterprise LLC · Pueblo, CON117MFJet Sales Of Stuart LLC · Stuart, FLN117RSJa1 Aviation LLC · Sedan, KSN117TJCoastal Community Real Estate Group LLC · Caswell Beach, NCN118NLPandd Partnership LLC · Oro Valley, AZN118SBEaglemed LLC · Wichita, KSN119ARCsc Delaware Trust Co Trustee · Wilmington, DEN119MCAgave III LLC · Seattle, WAN119SAInvestment Opportunities Pursuit LLC · Greenville, NCN11DTAzul Air LLC · Dover, DEN11SNSsj Holdings LLC · Modesto, CAN11WNRds Aviation LLC · Elkhart, INN1205SCounty Line Aviation LLC · Benton, KSN120NCDavis Aviation Inc DBA · Brandon, MSN120RLIsr Platforms LLC · Mclean, VAN120RPMallory & Evans Aviation LLC · Scottdale, GAN120SPAircraft Guaranty Corp Trustee · Oklahoma City, OKN1212International Air Services Inc Trustee · Carson City, NVN1212WTwo Drakes Air LLC · Lizella, GAN1213PL7 Air LLC · Chandler, AZN121BArgo Aviation LLC · Potsdam, NYN121BLOlson Brian D · Las Vegas, NVN121DKAutomotive Air II LLC · Belcamp, MDN121GJ424 Ventures LLC · Saint Petersburg, FLN121JGGo Consultants LLC · Wilmington, DEN121JPChoice Farms LLC · Wilmington, DEN121LBEastern Stearman Inc Trustee · Leesburg, VAN1221FTj Air Holdings Inc Trustee · Wilmington, DEN122BKFlying Mixers LLC · Amarillo, TXN122KMerlin Labs Inc · Boston, MAN122RGRiversville Aircraft Corp · Belgrade Lakes, MEN122UCentral Virginia Aviation Inc · North Dinwiddie, VAN1234ASbm Aviation LLC · Afton, WYN1234LRld Leasing Inc · Downers Grove, ILN123CHMdi Air LLC · Dothan, ALN123FWBhmp King Air LLC · Fort Worth, TXN123HGHorowitz Transportation LLC · Newport Beach, CAN123JFAlto Aero LLC · Dover, DEN123MHBryan-Kennedy LLC · Tulsa, OKN123MLNfbn LLC · Scottsdale, AZN123NKLarson Ken · Escondido, CAN123RFLucky Air LLC · Hobbs, NMN124CMSolomon Mark Trustee · Wilmington, DEN124EBPremium Air LLC · Hibbing, MNN124GADriscoll Health Care Services · Corpus Christi, TXN124KTGams Air LLC · Doral, FLN124MDKenmore Crew Leasing Inc Trustee · Bellingham, WAN124WRH.A.I. Services Inc · Justin, TX
Back to AD 97-25-01