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.

N729CKConair USA Co · Dover, DEBuilt 1982 · S/N 22982N73HKWilmington Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 21957N740ASAlaska Aviation Museum · Anchorage, AKBuilt 1981 · S/N 22578N7470Museum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20235N747SFAerospace Trust Management LLC Trustee · Wilmington, DES/N 21575N748FMStarling Aviation Services LLC · Lewes, DES/N 1561N748YKStarling Aviation Services LLC · Lewes, DES/N 1701N7520AAerothrust Holdings Leasing LLC · Miami, FLS/N 49897N752DHKalitta Charters II LLC · Ypsilanti, MIBuilt 1981 · S/N 22466N7541AFrontera Flight Holdings Inc · Dover, DEBuilt 1990 · S/N 49995N7548AFrontera Flight Holdings Inc · Dover, DES/N 53030N7550Frontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53032N770FGHangar LLC · Las Vegas, NVBuilt 1967 · S/N 116N782TWSierra American Corp · Wilmington, DEFirst renewal noticeBuilt 1967 · S/N 45826N783TWSierra American Corp · Wilmington, DEBuilt 1966 · S/N 47010N784TWSierra American Corp · Wilmington, DEBuilt 1967 · S/N 47014N794AJZero Gravity Corp · Merritt Island, FLBuilt 1976 · S/N 21243N797ALSkybus Jet Cargo Inc · Las Vegas, NVBuilt 1972 · S/N 46163N801WACaribbean Sun Airlines Inc DBA · Miami, FLBuilt 1992 · S/N 53291N802DHHeavylift Cargo Airlines Inc · Kingman, AZS/N 46076N803DHHeavylift Cargo Airlines Inc · Kingman, AZS/N 46123N804DHBjw Services Inc · Kingman, AZS/N 46091N805MLSmb Md-87 II LLC · Longwood, FLS/N 49777N806WA53251 LLC · Miami Springs, FLBuilt 1991 · S/N 53251N807WAFederal Dynamics Corp · Henderson, NVBuilt 1993 · S/N 53093N808CKKalitta Charters LLC · Ypsilanti, MIBuilt 1967 · S/N 108N808WACaribbean Sun Airlines Inc · Miami, FLBuilt 1990 · S/N 53044N809TARhoades Aviation Inc · Honolulu, HIBuilt 1987 · S/N 23796N810TARhoades Aviation Inc · Honolulu, HIBuilt 1975 · S/N 21116N813TLGeoairgroup LLC · Wilmington, DES/N 45732N8201Omega Air Inc · Selma, TXS/N 48201N8205Omega Air Inc · Selma, TXS/N 48205N8209Omega Air Inc · Selma, TXS/N 48209N820CKKalitta Charters LLC · Ypsilanti, MIBuilt 1967 · S/N 120N8222Omega Air Inc · Selma, TXS/N 48222N82247Omega Air Inc · Selma, TXS/N 48247N823VVOmega Air Inc · San Antonio, TXS/N 47823N8249Omega Air Inc · Selma, TXS/N 48249N824VVOmega Air Inc · San Antonio, TXS/N 47824N826VVOmega Air Inc · San Antonio, TXS/N 47826N8306Omega Air Inc · Selma, TXS/N 48306N8308Omega Air Inc · Selma, TXS/N 48308N8310Omega Air Inc · Selma, TXS/N 48310N852VOmega Air Inc · San Antonio, TXBuilt 1980 · S/N 47852N853VVOmega Air Inc · San Antonio, TXS/N 47853N858FTLogistic Air Inc · Reno, NVBuilt 1970 · S/N 20109N861GAWorld Atlantic Leasing LLC · Miami Springs, FLBuilt 1987 · S/N 49557N865FSkybus Jet Cargo Inc · Las Vegas, NVBuilt 1969 · S/N 46088N872SJHeavylift Cargo Airlines Inc · Kingman, AZS/N 46067N874AAAntares Aviation LLC · Boca Raton, FLBuilt 1978 · S/N 21386
Back to AD 75-08-17