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.

N422BNAntares Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 20735N438AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49456N438BNAntares Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 21045N44503Frontera Flight Holdings Inc · Dover, DEBuilt 1989 · S/N 49797N465TWSierra American Corp · Wilmington, DES/N 23465N467TWSierra American Corp · Wilmington, DES/N 23466N471EVGugu Ltd · Bellevue, WAS/N 20651N472EVFletcher Aviation Services LLC · Bismarck, NDBuilt 1971 · S/N 20320N481FLIfl Group Inc · Waterford, MIBuilt 1966 · S/N 27N482AAArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49675N483AArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49676N502DADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 21304N520TCDodson International Parts Inc · Rantoul, KSS/N 319N521FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 68N522AXBc Aircraft Leasing LLC · Albuquerque, NMBuilt 1988 · S/N 48315N553AAFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53083N556AAFrontera Flight Holding Inc · Dover, DEBuilt 1991 · S/N 53086N557ANPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53087N558AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53088N560AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53090N561AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53091N566AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49348N572AA727x Aerospace Corp · Lewes, DES/N 49458N573AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53092N574AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53151N576AAFronteraflight Holdings Inc · Dover, DES/N 53153N581AAFrontera Flight Holding Inc · Dover, DEBuilt 1991 · S/N 53158N583AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53160N585AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53248N586AAAerothrust Holdings Leasing LLC · Miami, FLS/N 53249N590AAFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53253N595AAPac Blue Aerospace · Fairbanks, AKBuilt 1992 · S/N 53285N603AXBc Aircraft Leasing LLC · Albuquerque, NMS/N 48267N612AXBc Aircraft Leasing LLC · Albuquerque, NMS/N 48290N615PA2d Aviation Corp · Frisco, TXBuilt 1976 · S/N 21266N617USLogistic Air Inc · Reno, NVBuilt 1975 · S/N 21121N618USLogistic Air Inc · Reno, NVBuilt 1975 · S/N 21122N621AXBc Aircraft Leasing LLC · Albuquerque, NMS/N 48319N637SHPacific Aircorp 49741 Inc · San Francisco, CAFirst renewal noticeS/N 49568N68UPRoyal Air Freight Inc · Waterford, MIBuilt 1971 · S/N 258N697BJTexas Air And Space Museum Inc · Amarillo, TXS/N 47799N708AAWorld Aviation Services LLC · Medley, FLBuilt 1981 · S/N 22465N720CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1977 · S/N 21298N721MNBd Md-87 LLC · Longwood, FLBuilt 1989 · S/N 49767N724CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1971 · S/N 20383N726USUSA Jet Airlines Inc · Belleville, MIBuilt 1981 · S/N 22469N727HLAviation Sales And Charter LLC · Dover, DES/N 22642N727NKAntares Aviation LLC · Boca Raton, FLBuilt 1979 · S/N 21945N727USUSA Jet Airlines Inc · Belleville, MIBuilt 1981 · S/N 22470N727YKFayaka Airways LLC · San Francisco, CANon-citizen corporation, flight hours not reportedS/N 21442
Back to AD 75-08-17