AD 84-10-01 R1

Registered aircraft · 20,486

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.

N157RDBoman & Kemp Lc · Ogden, UTBuilt 1999 · S/N 18280646N157STogo Aviation Services LLC · Palmer, AKBuilt 1955 · S/N 31840N157SMHumphreys James F · Charleston, WVBuilt 1998 · S/N 18280157N157ZZRegistered aircraftS/N 18280402N1581CFitzgerald Kenneth J · Millwood, WABuilt 1953 · S/N 30281N1581DChippewa Aero LLC · Montevideo, MNBuilt 1952 · S/N 7864N1584CHaakenson John R · Sterling, AKBuilt 1953 · S/N 30284N1585CHamilton Mark W · Durango, COBuilt 1953 · S/N 30285N1586DZucchero David M · Stanwood, WABuilt 1952 · S/N 7869N1587MSkywagons.Com LLC · Placerville, CAS/N 18264379N1587UGrant Aviation Inc · Anchorage, AKS/N 20700187N158CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281858N158CWMcdonald John C · Hallsville, TXBuilt 2004 · S/N 18281381N158DNiehaus James O · Erie, COBuilt 1961 · S/N 1850232N158FCDept Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2008 · S/N 18282062N158JRCollins Stephen Neil · Clancy, MTS/N 18280051N158PAndry Holdings LLC · Missoula, MTBuilt 2008 · S/N 20608306N1591DBrewer George F II · Colorado Springs, COBuilt 1952 · S/N 7874N1591FBaer Monte Wayne · Ronan, MTBuilt 1966 · S/N 185-0973N1592CPulver Douglas A · Kenockee, MIBuilt 1953 · S/N 30292N1592FReynolds Frederick A · Pilot Point, AKBuilt 1966 · S/N 185-0974N1592MDumais Robert J · Tilton, NHBuilt 1975 · S/N 18264382N1593CPeacock Richard M · Swansboro, NCS/N 30293N1594CFlyrs Field · Anchorage, AKBuilt 1953 · S/N 30294N1595FVertical Horizon Aviation LLC · Sandown, NHBuilt 1966 · S/N 185-0977N1595UJoiner Aviation LLC · Vinemont, ALBuilt 1973 · S/N U20602269N1596CFennell Kenneth J · Palmer, AKBuilt 1953 · S/N 30296N1596MKret Geoffrey W · Godley, TXBuilt 1975 · S/N 18264386N1597MDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 18264387N1598MZigler James B · Big Lake, MNBuilt 1975 · S/N 18264388N159CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281859N159DRPiedmont Flight Inc · Winston Salem, NCBuilt 1998 · S/N 18280128N159FCDept Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2008 · S/N 18282065N15APIndy Air Sales LLC · Anderson, INBuilt 1976 · S/N 18264944N15AZHopkins Todd · Russellville, INBuilt 1979 · S/N 18267118N15BFMayes Richard A · Bend, ORBuilt 1973 · S/N 18052353N15BPTidmore Argie D · Pottsville, PABuilt 1979 · S/N 18266877N15DACamborne USA LLC · Collierville, TNS/N 21061765N15MLN15ml LLC · Cresskill, NJBuilt 1977 · S/N 21061780N15MVAir Bellers Inc · Sunnyvale, CABuilt 2017 · S/N 18282388N15MWZeezee LLC · Phoenix, AZBuilt 1978 · S/N 21063023N15PAFlight Dynamics LLC · De Leon Springs, FLBuilt 1980 · S/N 18053148N15RSCalvert Gregory E · Essex, MDBuilt 1973 · S/N 18261885N15SZZurcher Susan R · Hampshire, ILBuilt 2022 · S/N 18283202N15TBEast West Helicopter Inc · Batesville, INBuilt 1979 · S/N 21063331N15USFlypower Inc · Fort Lauderdale, FLBuilt 1975 · S/N 21060676N15WGSwirk Rhonda L · Center Conway, NHBuilt 1968 · S/N 18259444N15ZFRegistration Pending · Swan Valley, IDRegistration pendingBuilt 1977 · S/N 18052802N1600XLd&B LLC · Show Low, AZS/N 21060636N1601CRoss Dale · Washtucna, WABuilt 1953 · S/N 30301
Back to AD 84-10-01 R1