AD 97-17-05
Registered aircraft · 142
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-17-05')
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-17-05')
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-17-05') 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-17-05') 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.
N449YVBank Of Utah Trustee · Salt Lake City, UTN465PAUniversal Exports LLC · Miami, FLN480AVBerry Aviation Inc · San Marcos, TXN492BABerry Aviation Inc · San Marcos, TXN510KTSch Aviation Inc Trustee · SporleN524AWUS Air Force Special Operations Command · Hurlburt Field, FLN525EFU S Air Force Special Operations Command · Hurlburt Field, FLN541AVSierra Nevada Company LLC · Sparks, NVN545EFUS Air Force Special Operations Command · Hurlburt Field, FLN556PM645 Aeronautical Systems Group (Aesg) · Wpafb, OHN560SWJahn 560sw LLC · Miami, FLN561SWBerry Aviation Inc · San Marcos, TXN564SWFreight Runners Express Inc · Milwaukee, WIN565EFUS Air Force Special Operations Command · Hurlburt Field, FLN566SWJahn566sw LLC · Miami, FLN567SWJahn 567sw LLC · Miami, FLN570EFPrattville Turbine Engines LLC · Prattville, ALN577EFU S Air Force Special Operations Command · Hurlburt Field, FLN578SWJahn641bc LLC · Miami, FLN584SWBerry Aviation Inc · San Marcos, TXN586SWBerry Aviation Inc · San Marcos, TXN597SBInternational Air Services Inc Trustee · Carson City, NVN619GNBank Of Utah Trustee · Salt Lake City, UTN645HM645th Aeronautical Engineering Group (Aesg) · Wright Pat, OHN646CCBank Of Utah Trustee · Salt Lake City, UTN649CCBank Of Utah Trustee · Salt Lake City, UTN650CTBerry Aviation Inc · San Marcos, TXN651CTBerry Aviation Inc · San Marcos, TXN652CTAviation Management Sales LLC · Fort Pierce, FLN653CTAmeriflight LLC · Dallas, TXN706XTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN707TGBerry Aviation Inc · San Marcos, TXN774DKOrr Franklin M Jr Trustee · Stanford, CAN798CRSouthwest Aviation Enterprises · Haslet, TXN801HCAirline Contract Maintenance And Equipment Inc · Honolulu, HIN801MRUS Department Of Homeland Security · Washington, DCN802MRDepartment Of Homeland Security · Washington, DCN803MRDepartment Of Homeland Security · Washington, DCN805FXFederal Express Corp · Memphis, TNN805MRUS Department Of Homeland Security · Washington, DCN806FXFederal Express Corp · Memphis, TNN806MRUS Department Of Homeland Security · Washington, DCN807EXFrontera Flight Holdings Inc · Dover, DEN807FXFederal Express Corp · Memphis, TNN807MRUS Department Of Homeland Security · Washington, DCN808MRUS Department Of Homeland Security · Washington, DCN8100LDynamic Avlease Inc · Bridgewater, VAN8100VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN810FXFederal Express Corp · Memphis, TNN811FXFederal Express Corp · Memphis, TN
Back to AD 97-17-05