OpenAirDocs.org
AD 75-19-05

Registered aircraft · 58

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-19-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:75-19-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.

N100VQNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 140N109SBSabre Direct · Chicago, ILS/N 380-20N1121RAlbert Lea Airport · Albert Lea, MNBuilt 1969 · S/N 125N119BARegistration Pending · Tucson, AZRegistration pendingBuilt 1965 · S/N 23-084N120RARoyal Air Freight Inc · Waterford, MIS/N 211N123DGDavis Air LLC · Vero Beach, FLBuilt 1976 · S/N 342N123RARoyal Air Freight Inc · Waterford, MIBuilt 1966 · S/N 30N148TWSierra American Corp · Wilmington, DEBuilt 1968 · S/N 148N158TWSierra American Corp · Wilmington, DEBuilt 1968 · S/N 158N175FSJet Set 1 LLC · Kalispell, MTBuilt 1965 · S/N 031N192CKKalitta Charters LLC · Ypsilanti, MIS/N 192N200YClassic Lear Jet Foundation · Wichita, KSS/N 23-003N204TWSierra American Corp · Wilmington, DEBuilt 1969 · S/N 204N209CAAloft Aviation LLC · Hampton, GAS/N 71N20FJDodson International Parts Inc · Rantoul, KSS/N 119N218CAAloft Aviation LLC · Hampton, GAS/N 218N221TWSierra American Corp · Wilmington, DEBuilt 1969 · S/N 221N226CKKalitta Charters LLC · Ypsilanti, MIBuilt 1970 · S/N 226N229CKKalitta Charters LLC · Ypsilanti, MIBuilt 1970 · S/N 229N22ESSmith James E Trustee · Kalispell, MTBuilt 1957 · S/N 57-565N234GAviation Buisness Corp · Saint Louis, MOBuilt 1965 · S/N 28N237TWTechnical Education Services Inc DBA · Virginia Beach, VABuilt 1970 · S/N 237N23BYYounkin Matthew A · Siloam Springs, ARBuilt 1965 · S/N 23-009N249HPSale Reported · Camden, DESale reportedBuilt 1975 · S/N 301N24VJColombo Brian · Oswego, NYBuilt 2010 · S/N 021N24WXTre Aviation Corp · Wilmington, DEBuilt 1966 · S/N 101N251TSLopez Fabio A · Denver, NCBuilt 1975 · S/N 201N25CYN25cy LLC · West Palm Beach, FLS/N 272N26ATDel Mar College · Corpus Christi, TXBuilt 1973 · S/N 130N27BJCbg LLC · Wilsonville, ORBuilt 1971 · S/N 227N283SADodson International Parts Inc · Rantoul, KSS/N 83N299JCRoyal Air Freight Inc · Waterford, MIBuilt 1974 · S/N 299N30FTSkyview LLC · Wilmington, DEBuilt 1975 · S/N 330N3137Avstar Inc · Seattle, WABuilt 1966 · S/N 123N314TWSierra American Corporation · Wilmington, DEBuilt 1974 · S/N 314N335TWInternational Turbine Indutries LLC · Ypsilanti, MIS/N 335N378DBSkyview LLC · Wilmington, DEBuilt 1978 · S/N 378N424RTechnical Education Services Inc · Virginia Beach, VABuilt 1974 · S/N 380-15N45ED45ed LLC · Calhoun, GABuilt 1966 · S/N 104N473TCTulsa Technology Center School District #18 · Tulsa, OKBuilt 1969 · S/N 043N477KRegistered aircraftBuilt 1965 · S/N 23036N481FLIfl Group Inc · Waterford, MIBuilt 1966 · S/N 27N49GSAvstar Inc · Seattle, WABuilt 1976 · S/N 336N49WAFleet Unlimited Inc · Pasadena, CABuilt 1973 · S/N 142N556KVasenden Arnold · Midlothian, TXBuilt 1957 · S/N 144223AN56MMCarlisle Air LLC · Locust Valley, NYBuilt 1976 · S/N 332N581FLIfl Group Inc · Waterford, MIBuilt 1981 · S/N 440N606SMTechnical Education Services Inc · Virginia Beach, VABuilt 1974 · S/N 185N68LULewis University · Romeoville, ILBuilt 1968 · S/N 163N721SFSpirit Of Flight Foundation · Nampa, IDBuilt 1976 · S/N 325
Back to AD 75-19-05