AD 75-08-17
Registered aircraft · 209
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:75-08-17')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-08-17')
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:75-08-17') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-08-17') 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.
N729CKConair USA Co · Dover, DEN73HKWilmington Trust Co Trustee · Wilmington, DEN740ASAlaska Aviation Museum · Anchorage, AKN7470Museum Of Flight Foundation · Seattle, WAN747SFAerospace Trust Management LLC Trustee · Wilmington, DEN748FMStarling Aviation Services LLC · Lewes, DEN748YKStarling Aviation Services LLC · Lewes, DEN7520AAerothrust Holdings Leasing LLC · Miami, FLN752DHKalitta Charters II LLC · Ypsilanti, MIN7541AFrontera Flight Holdings Inc · Dover, DEN7548AFrontera Flight Holdings Inc · Dover, DEN7550Frontera Flight Holdings Inc · Dover, DEN770FGHangar LLC · Las Vegas, NVN782TWSierra American Corp · Wilmington, DEFirst renewal noticeN783TWSierra American Corp · Wilmington, DEN784TWSierra American Corp · Wilmington, DEN794AJZero Gravity Corp · Merritt Island, FLN797ALSkybus Jet Cargo Inc · Las Vegas, NVN801WACaribbean Sun Airlines Inc DBA · Miami, FLN802DHHeavylift Cargo Airlines Inc · Kingman, AZN803DHHeavylift Cargo Airlines Inc · Kingman, AZN804DHBjw Services Inc · Kingman, AZN805MLSmb Md-87 II LLC · Longwood, FLN806WA53251 LLC · Miami Springs, FLN807WAFederal Dynamics Corp · Henderson, NVN808CKKalitta Charters LLC · Ypsilanti, MIN808WACaribbean Sun Airlines Inc · Miami, FLN809TARhoades Aviation Inc · Honolulu, HIN810TARhoades Aviation Inc · Honolulu, HIN813TLGeoairgroup LLC · Wilmington, DEN8201Omega Air Inc · Selma, TXN8205Omega Air Inc · Selma, TXN8209Omega Air Inc · Selma, TXN820CKKalitta Charters LLC · Ypsilanti, MIN8222Omega Air Inc · Selma, TXN82247Omega Air Inc · Selma, TXN823VVOmega Air Inc · San Antonio, TXN8249Omega Air Inc · Selma, TXN824VVOmega Air Inc · San Antonio, TXN826VVOmega Air Inc · San Antonio, TXN8306Omega Air Inc · Selma, TXN8308Omega Air Inc · Selma, TXN8310Omega Air Inc · Selma, TXN852VOmega Air Inc · San Antonio, TXN853VVOmega Air Inc · San Antonio, TXN858FTLogistic Air Inc · Reno, NVN861GAWorld Atlantic Leasing LLC · Miami Springs, FLN865FSkybus Jet Cargo Inc · Las Vegas, NVN872SJHeavylift Cargo Airlines Inc · Kingman, AZN874AAAntares Aviation LLC · Boca Raton, FL
Back to AD 75-08-17