AD 97-06-06
Registered aircraft · 2,038
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-06-06')
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-06-06')
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-06-06') 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-06-06') 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.
N175SAGeneral Atomics · San Diego, CAN176JRKimmel Aviation Insurance Agency Inc · Greenwood, MSN176LABallard Aviation Inc · Newton, KSN176MRegent Trust Corp Trustee · Wichita, KSN176TWSierra American Corporation · Wilmington, DEN176YVHill Air Executive Inc · Fort Pierce, FLN177CNRca Aviation 2 LLC · Tempe, AZN177LACabeza De Vaca Holdings LLC · Carrollton, TXN177MKTrans Equipment Svcs Inc · Greenville, SCN17812Best Aircraft Deals LLC · Salt Lake City, UTN178LAPonca International LLC · Bentonville, ARN178YVAlpine Aviation Inc · Provo, UTN179MDGem City Properties LLC · Laramie, WYN17EHSystem Packaging Co Inc · Bell, CAN17KKRiverbend Aviation LLC · Hernando, MSN17NMCentral Virginia Aviation Inc · Petersburg, VAN17VAOptimal Aviation Services LLC · Visalia, CAN17WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1801BSjd Flight LLC · Houston, TXN182CASky West Aviation Inc Trustee · Albuquerque, NMN183SADriscoll David A · Savannah, TNN18471Chase Air LLC · Montgomery, ALN1848ST&T Air LLC · Lindsay, OKN184TXZms Aviation LLC · Wilmington, DEN184UXAlpine Aviation Inc · Provo, UTN1857F56 Express LLC · Willmar, MNN185MVSouthwest Aviation Inc Div · Marshall, MNN187ALAlm Holdings Delaware 2 LLC · Wilmington, DEN187MRJcs Air LLC · Auburn, ALN188ALAlm Holdings Delaware 3 LLC · Wilmington, DEN188LLTriple Aviation LLC · San Leon, TXN189ALAlm Holdings Delaware 4 LLC · Wilmington, DEN189APRegistered aircraftN189WAAmeriflight LLC · Dallas, TXN18AFN220pb LLC · Mesa, AZN18CMEdgewater Aviation LLC · Guntersville, ALFirst renewal noticeN18KATreetoppers II LLC · Newark, DEN18MYWorld Aircraft Leasing Inc · Wilmington, DEFirst renewal noticeN18SFD&D Maintenance LLC · Etna Green, INN1902DBoeing Co · Berkeley, MON190AWCsi 135 Division LLC · Albuquerque, NMN190BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN190BHJourney Aviation LLC · Brookland, ARN190EBKar King LLC · Huntington, WVN190EFTriple E Farms LLC · Pasco, WAN190FDOreh Aircraft LLC · New Braunfels, TXN190GAAlpine Aviation Inc · Provo, UTN190JPClearwater Midstream LLC · Lubbock, TXN190NCCf Holdings LLC · Hernando, MSN190PMPlanemasters Ltd · West Chicago, IL
Back to AD 97-06-06