OpenAirDocs.org
AD 84-10-01 R1

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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.

N624CGChristy Alan · Pendleton, ORBuilt 1966 · S/N 18257270N624DRRyan Air Inc · Anchorage, AKBuilt 1979 · S/N 20700517N624ERRyan Air Inc · Anchorage, AKBuilt 1982 · S/N 20700752N624MAurora Aviation LLC · Delray Beach, FLBuilt 1978 · S/N 18266624N624MTJcct Holdings LLC · Plano, TXBuilt 1978 · S/N 210-62913N624WOh-Yeah LLC · Caldwell, IDBuilt 1982 · S/N 18268192N6251RCalley Adelia M · Big Lake, TXBuilt 1974 · S/N 18262789N6253APiper David L · Peshastin, WABuilt 1956 · S/N 33053N6255ABennett Dennis Lane Jr · Hastings, MIBuilt 1956 · S/N 33055N6255HRenfro Michael W · Bethel, AKS/N 20700452N6257ASmolinski Michael E · Withams, VABuilt 1956 · S/N 33057N6259EN6259e LLC · Richardson, TXBuilt 1983 · S/N 18268354N625KWSchmoker William C · Eden Prairie, MNBuilt 1974 · S/N U20602635N625LSPhoenix Flyers Inc · Mesa, AZBuilt 2004 · S/N 18281356N625MBGood And Young LLC · Wilmington, DEBuilt 1964 · S/N 18255233N625MMRamsdell Myron J · Hartwell, GABuilt 1965 · S/N 18051625N6260NAbm Aviation LLC · Wilmington, DEBuilt 1981 · S/N 18267812N6261AAviation Of North Florida LLC · Jacksonville, FLBuilt 1956 · S/N 33061N6261FEllis Matthew W · Sabina, OHBuilt 1975 · S/N 18264143N6263AHusbands Jason · Belen, NMBuilt 1956 · S/N 33063N6264ATurley Joseph D · Mcalester, OKBuilt 1956 · S/N 33064N6265FRichards Mattew J · Crystal Beach, FLBuilt 1975 · S/N 18264144N6266EStraight Fly LLC · West Jordan, UTBuilt 1983 · S/N 18268355N6266FSilver 7 Aero LLC · Scott City, KSBuilt 1975 · S/N 18264145N6266HNovi Inc · Ruby, AKBuilt 1978 · S/N 20700457N6267YZero Four Twelve LLC · Clovis, NMBuilt 1981 · S/N 21064313N6268AHenshaw Jon R · Miami, FLBuilt 1956 · S/N 33068N6268NCompass Rose Aviation · Derby, KSBuilt 1981 · S/N 18267814N6268RYouvan Ian · Pittsburg, KSS/N 31418N6269ABubs Tub LLC · San Angelo, TXBuilt 1956 · S/N 33069N6269TN6269t · Lampe, MOBuilt 1983 · S/N R18201952N626DTA & F Aviation Services LLC · Collierville, TNBuilt 1979 · S/N 18266784N626KTRustair Inc · Anchorage, AKS/N U20604426N626RPWhitaker Jesse G · Anchorage, AKBuilt 1955 · S/N 31659N6270XLees Robert A II · Mesa, AZBuilt 1980 · S/N U20605851N6271AAshley Edward A · San Antonio, TXBuilt 1956 · S/N 33071N6271BCountry Flyin Inc · Homestead, FLBuilt 1977 · S/N U20603839N6273AStreufert Colton P · Boise, IDBuilt 1956 · S/N 33073N6274AA V T210 LLC · Palmdale, CABuilt 1979 · S/N 21063517N6274TGlenum Donald L III · Norfolk, VABuilt 1983 · S/N R18201954N6275ABrown Thomas C · Littlefield, TXBuilt 1956 · S/N 33075N6275SMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2008 · S/N 18282100N6276BN6276b LLC · Katy, TXS/N 21062730N6277AElliott Aviation LLC · Bliss, IDBuilt 1956 · S/N 33077N6277ZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N U20606211N6278SFlick Damon · Dansville, NYBuilt 1980 · S/N R18201657N6278YTown & Country Aviation LLC · Sunnyvale, CABuilt 1981 · S/N 21064318N62799Dutchflier Captial LLC · New Hudson, MIBuilt 2008 · S/N 18282056N6279NDavan Karissa J · Phippsburg, MEBuilt 1981 · S/N 18267818N627KWOrion Aviation Aircraft LLC · Carlsbad, CABuilt 1972 · S/N 18261271
Back to AD 84-10-01 R1