AD 97-01-13
Registered aircraft · 54,837
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-01-13')
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-01-13')
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-01-13') 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-01-13') 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.
N2197YWeber Raymond E · Palmer, AKN21980Harris Kenneth L · Greeley, CON21981Mahoney Thomas H · Dorrance, KSN21986Corr Harvey R · Nipomo, CAN2198GAirstar Aviation Inc · Chester, SCN2198ROlson Darryld A · Buckley, WAN2198SPeavey Brian H · Houston, TXN2198YCustard Ray · Houston, TXN21990Mcmahan William K · Sandy Valley, NVN21997Myers Donald W II · Saint Francisville, LAN2199GEmery Craig A · Wasilla, AKN2199UWood James DBA · Memphis, MON219JKMiller Charles Jr · Kill Devil Hills, NCN219RADorshorst Dustin J · Deforest, WIN21ADBogart Donald W Jr · Long Beach, CAN21ATMeadville Aero Club LLC · Erie, PAN21BESpecialized Helicopter Training LLC · Middleton, IDN21BMGandee James T · Bullhead City, AZN21CFSmith Robert R · Benton, LAN21CPT Howard And Associates Architects Inc · Dallas, TXN21CSHendrix Peter A · Plantation, FLN21CTFerreira Douglas B Trustee · Chico, CAN21DFDose Gary W · Pinehurst, IDN21EBSunview Flying Service LLC · Jordan, NYN21EWRountree Christopher B · Burbank, CAN21FC310 Pals LLC · Lake City, FLN21FFHor Aviation LLC · Harrisburg, PAN21GBSouthern Aircraft Consultancy Inc Trustee · Casper, WYN21GFBas Part Sales LLC · Greeley, CON21HAEngle Scott · Plymouth, MNN21KBLow Carl S III · Aurora, TXN21KDMrd Aviation LLC · Windsor, CON21KRNorcon Enterprises Inc · Amarillo, TXFirst renewal noticeN21LDCaswell Bruce · Charleston, WVN21LS7ac Aviation LLC · Fort Worth, TXN21LTMission Flight · El Monte, CAN21LWRegistered aircraftN21MBAarons David J · Birmingham, ALN21PLYankee Flying Club Inc · Maple Grove, MNN21PVPeterson Kirk A · Nixa, MON21RGMacair Aviation LLC · Xenia, OHN21RHWogan Joseph M · Mesa, AZN21RPJ-Dawgs Aviation LLC · Greenville, NCN21SGTwo One Sierra Golf LLC · Seattle, WAN21SJPointcloud Aviation LLC · Plymouth, MNN21SSMidwest Corporate Air Inc · Bellefontaine, OHN21TBAughinbaugh Christopher · Rancho Cordova, CAN21TGSale Reported · Cape Coral, FLSale reportedN21TNNavar Thomas R Jr · El Paso, TXN21WUDallas Aero & Sales LLC · Poplar, MT
Back to AD 97-01-13