OpenAirDocs.org
AD 80-08-06 R1

Registered aircraft · 67

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:80-08-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-08-06-R1')
  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 140N101VSCalspan Corporation · Buffalo, NYBuilt 1969 · S/N 218N102VSCalspan Corp · Buffalo, NYBuilt 1974 · S/N 180N109SBSabre 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-003N203VSCalspan Corp · Buffalo, NYBuilt 1981 · S/N 347N204TWSierra 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 272N262AZCollings Foundation · Stow, MABuilt 2002 · S/N 501241N26ATDel 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 299N304VSCalspan Corp · Buffalo, NYBuilt 1981 · S/N 354N30FTSkyview LLC · Wilmington, DEBuilt 1975 · S/N 330N3137Avstar Inc · Seattle, WABuilt 1966 · S/N 123N314TWSierra American Corporation · Wilmington, DEBuilt 1974 · S/N 314N330LA-C Electric Co · Bakersfield, CABuilt 1981 · S/N 330N335TWInternational Turbine Indutries LLC · Ypsilanti, MIS/N 335N378DBSkyview LLC · Wilmington, DEBuilt 1978 · S/N 378N424RTechnical Education Services Inc · Virginia Beach, VABuilt 1974 · S/N 380-15N456CGLdl Aircraft Leasing LLC · Pittsfield, MABuilt 1981 · S/N 343N45ED45ed 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 27N499BSNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 239
Back to AD 80-08-06 R1