AD 96-09-13
Registered aircraft · 772
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:96-09-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:96-09-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:96-09-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:96-09-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.
N169GLAlpine Aviation Inc · Provo, UTN169RWJorgensen Air Service LLC · Puyallup, WAN16CMBartholow Rental Co Inc · Wylie, TXN16HGBear Air LLC · Mount Vernon, INN170GLAlpine Aviation Inc · Provo, UTN170JCWlgb200 LLC · Reno, NVN171CJBering Air Inc · Nome, AKN172EEBemidji Aviation Services Inc · Bemidji, MNN172GAAlpine Aviation Inc · Provo, UTN173TX173 Tango X-Ray LLC · Houston, TXN174AVUas Transervices Inc · Boca Raton, FLN174JBAes Aviation LLC · Tuskegee, ALN175EEBemidji Aviation Services Inc · Bemidji, MNN176YVHill Air Executive Inc · Fort Pierce, FLN177LACabeza De Vaca Holdings LLC · Carrollton, TXN178YVAlpine Aviation Inc · Provo, UTN17EHSystem Packaging Co Inc · Bell, CAN17WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN184TXZms Aviation LLC · Wilmington, DEN184UXAlpine Aviation Inc · Provo, UTN185MVSouthwest Aviation Inc Div · Marshall, MNN189WAAmeriflight LLC · Dallas, TXN18AFN220pb LLC · Mesa, AZN1902DBoeing Co · Berkeley, MON190AWCsi 135 Division LLC · Albuquerque, NMN190BHJourney Aviation LLC · Brookland, ARN190EBKar King LLC · Huntington, WVN190GAAlpine Aviation Inc · Provo, UTN190PMPlanemasters Ltd · West Chicago, ILN190TTAcme Jet LLC · Dover, DEN190WAAmeriflight LLC · Dallas, TXN191AVUas Transervices Inc · Boca Raton, FLN191AWCsi 135 Division LLC · Albuquerque, NMN191CSTvpx Ars Inc Trustee · North Salt Lake, UTN191CZPlanemasters Ltd · West Chicago, ILN191WAAmeriflight LLC · Dallas, TXN1924TUas Transervices Inc · Boca Raton, FLN192GAAlpine Aviation Inc · Provo, UTN192WAAmeriflight LLC · Dallas, TXN193CZPlanemasters Ltd · West Chicago, ILN193SUUas Transervices Inc · Boca Raton, FLN194GAAlpine Aviation Inc · Provo, UTN194TRExecutive Air Taxi Corp · Bismarck, NDN195AWCsi 135 Division LLC · Albuquerque, NMN195GLAlpine Aviation Inc · Provo, UTN196SCChickasaw Transport LLC · Santa Rosa Beach, FLN196WAAmeriflight LLC · Dallas, TXN197GAAlpine Aviation Inc · Provo, UTN197WAAmeriflight LLC · Dallas, TXN198AWCsi Aviation Inc · Albuquerque, NM
Back to AD 96-09-13