OpenAirDocs.org
AD 80-09-03 R1

Registered aircraft · 744

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-09-03-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-09-03-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.

N944TFCornerstone Leasing Of The Texas Panhandle LLC · Panhandle, TXBuilt 1976 · S/N LW-177N946AMGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1978 · S/N LJ-815N948HBNew Mountain Aviation LLC · Englewood, COBuilt 1980 · S/N BE-98N94CDSteel Clad Inc · Greenville, SCBuilt 1980 · S/N LJ-939N94HBVms Aviation Services LLC · Ardmore, OKBuilt 1980 · S/N LJ-904N953RCRmc Aviation LLC · Trumann, ARBuilt 1980 · S/N BE-94N958JHAims Community College · Greeley, COS/N LJ-1108N95LBTate James D · Christiansted, VIS/N LW-24N963KAMeshoppen Air LLC · Tunkhannock, PABuilt 1977 · S/N LW242N964GBTango Papa Whiskey LLC · Manchester Center, VTBuilt 1981 · S/N LJ-1007N965LGGoody Birds LLC · Prattville, ALBuilt 1976 · S/N LW-204N969MAVenable Group LLC · Tupelo, MSBuilt 1981 · S/N BB-894N970KRJetx Aviation LLC · New Bern, NCBuilt 1979 · S/N BB-454N971AMHoefler Wayne F · Colorado Springs, COBuilt 1981 · S/N LJ-983N973GACentral Virigina Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N LJ675N975SPSky Power LLC · Albuquerque, NMBuilt 1977 · S/N LW-263N976KCTennessee River Steel LLC · Stevenson, ALBuilt 1979 · S/N BB-601N977AAGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1972 · S/N LJ-555N980VCN980vc Corp · Wilmington, DEBuilt 1977 · S/N BE19N982GAMadaket Atlas LLC · Nantucket, MABuilt 1976 · S/N BB-149N982TMAt Aero LLC · Wilmington, DEBuilt 1977 · S/N BB-226N9838ZN B B S LLC · Kansas City, KSFirst renewal noticeBuilt 1969 · S/N LJ-435N984MAExtraordinary Air LLC · Greenville, SCBuilt 1980 · S/N LJ883N987ABDirty Joe Aviation LLC · Windsor, CABuilt 1978 · S/N LW-269N988SLInternational Services Management LLC · Heath, TXBuilt 1969 · S/N LJ-438N98ARRyan Gordon Air LLC · Santa Ana, CABuilt 1979 · S/N LJ829N98HFValiair Ltd Co Trustee · Casper, WYBuilt 1973 · S/N LW-89N98KCBelles Aviation LLC · Missoula, MTBuilt 1976 · S/N BB172N98PMTcp One LLC · Amarillo, TXBuilt 1974 · S/N LW-131N98RADenaina Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N BB439N98TACentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N BE-56N98VGBarron 301p LLC · Olive Branch, MSBuilt 1977 · S/N BB-252N990CBB & G Aircraft LLC · Flanders, NJBuilt 1994 · S/N LJ-1362N990LSK&A Advisors LLC · Wilmington, DEBuilt 1975 · S/N LJ-677N990SHAviation Co Inc · Cheyenne, WYBuilt 1976 · S/N BC-12N991SUAviation Enterprises LLC · Longwood, FLBuilt 1977 · S/N BB-253N997LMLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1976 · S/N BB217N999DTX Stallion Ventures LLC · Jacksonville, TXBuilt 1976 · S/N BB-138N999ESGatewood Aviation LLC · Lakeway, TXBuilt 1973 · S/N LJ-612N999SFN999sf LLC · Amarillo, TXBuilt 1972 · S/N LW-5N99ACRejo Inc · Wilmington, DEBuilt 1974 · S/N LW-120N9HWMullins Michael · Seaford, DEBuilt 1969 · S/N LJ-459N9UZCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 1974 · S/N LJ641N9VCArocosta LLC · Coral Gables, FLBuilt 1978 · S/N LJ-763
Back to AD 80-09-03 R1