OpenAirDocs.org
AD 84-10-01 R1

Registered aircraft · 20,483

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.

N311HPOhio Department Of Public Safety · Columbus, OHS/N 18280919N311JMN311jm LLC · Lake City, FLBuilt 2007 · S/N 18281891N311KPPickard Kevin P · Washington, MIBuilt 2023 · S/N 18283230N311MMAndrews Karen · Napa, CABuilt 1978 · S/N R18200366N311SBNbr Aviation · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282246N311SFBaymag Aviation LLC · Mountain Home, ARBuilt 1968 · S/N 18259047N311TLM & N Enterprises LLC · Topeka, KSBuilt 1981 · S/N 18267937N3120FLengyel Roger · Santa Fe, NMBuilt 1966 · S/N 18257220N3120QLinda In The Sky LLC · Webster, MNBuilt 1967 · S/N 18258120N3120RBulang Investments LLC · Newbury, NHS/N 18258520N3121DFrey Jerry P · Fallon, NVBuilt 1955 · S/N 31919N3121FLily Chris H · Ocala, FLBuilt 1966 · S/N 18257221N3122STecumseh Skydiving School LLC · Tecumseh, MIBuilt 1964 · S/N 18255622N3122YJti Management LLC · Colfax, WAS/N 18254122N3123CRmc Aviators LLC · Wilmington, DEFirst renewal noticeBuilt 1954 · S/N 30922N3123QDarkhorse Six Inc · Boerne, TXBuilt 1967 · S/N 18258123N3123RHs Aviation Holdings LLC · Eagle, IDBuilt 1967 · S/N 18258523N3123SGabin LLC · Tulsa, OKBuilt 1964 · S/N 18255623N3123YAbecca Corporation · Jackson, MIBuilt 1962 · S/N 18254123N3124DBurch David C · Flushing, MIBuilt 1955 · S/N 31922N3124FTrue Aviators LLC · Kiowa, KSBuilt 1966 · S/N 18257224N3124RMidland Liberty LLC · Midland, MIBuilt 1967 · S/N 18258524N3125DDavis Ronald L Jr · Soldotna, AKBuilt 1955 · S/N 31923N3125FHall Aircraft LLC · Kenai, AKS/N 18257225N3125QSunrise Aviation Llp · Gig Harbor, WABuilt 1967 · S/N 18258125N3125WRowe Benjamin Stratton · Nome, AKBuilt 1959 · S/N 50584N3125YOberdoerster Timothy L · Concord Township, OHS/N 18254125N3126CWest Leland Dan · Elverta, CAS/N 30925N3126DMyers Martin John Trustee · Juneau, AKBuilt 1955 · S/N 31924N3126YOutdoor Freedom Inc · Camdenton, MOBuilt 1962 · S/N 18254126N3127CChaar LLC · Lock Haven, PAS/N 30926N3127DE & S Group LLC DBA · Columbia, CABuilt 1955 · S/N 31925N3127EAllison John W Jr · Brighton, COBuilt 1953 · S/N 30087N3127FN3127f Aviation LLC · Charlotte, NCBuilt 1966 · S/N 18257227N3128DCopsey Harvey J · Tucson, AZBuilt 1955 · S/N 31926N3128FSwartzendruber Rodney S · Bay Port, MIBuilt 1966 · S/N 18257228N3128QK Bell Enterprises Inc · Columbia Falls, MTBuilt 1967 · S/N 18258128N3128RHuelsmann Gayle M · Albuquerque, NMBuilt 1967 · S/N 18258528N3129DHawgs Landing LLC · Warrensburg, MOBuilt 1955 · S/N 31927N3129QUrbanowski Edward F · Paxton, MAS/N 18258129N312KMBaer Ryan D · Missoula, MTBuilt 1957 · S/N 32846N312RMSunny Days Prop Jox LLC · Niceville, FLBuilt 2000 · S/N 18280872N312SCBarker Family Investments Management Co LLC · Tyler, TXBuilt 1981 · S/N 21064474N312XYAir Surgeon I LLC · Miami, FLBuilt 2023 · S/N 18283222N3130CUlrich Alex E · Atlanta, ILBuilt 1954 · S/N 30929N3130FRoxy Aviation LLC · Bristol, RIBuilt 1966 · S/N 18257230N3130SN3130s Corporation · Wilmington, DEBuilt 1964 · S/N 18255630N3130UW&J Aviation And Aerial Photography LLC · Brighton, MIBuilt 1963 · S/N 18254530N3130YScholz Mark W · Atchison, KSS/N 18254130N3131DLeggett Brandon L · Gatesville, TXFirst renewal noticeS/N 31929
Back to AD 84-10-01 R1