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.

N4809NNewland John G · Eagle, IDBuilt 1979 · S/N 18267383N4809USchutze Curt K · Santa Paula, CABuilt 1963 · S/N 205-0509N480SCZephyr Services LLC · Long Beach, CABuilt 1978 · S/N R18200455N4810YInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 21064013N4811DAbidance Inc · Winthrop, WABuilt 1958 · S/N 34911N4811NMiller Edwin C · Proctor, WVS/N 18267385N4811USwartz Ryan W · Pierre, SDBuilt 1963 · S/N 205-0511N4812CRennekamp Eric J · Andersonville, TNBuilt 1981 · S/N 18268132N4812FNorth American Aerial Surveys LLC · Tucson, AZBuilt 1966 · S/N U206-0512N4812UFoster Frank Brian · Goldsboro, NCS/N 205-0512N4814Crawford Benjamin D · Anchorage, AKBuilt 1957 · S/N 32847N4814UHash Marshall T · Inglis, FLBuilt 1963 · S/N 2050514N4815Ober John A · Candor, NYS/N 18053056N4815DBodeen Lance A · Eagle River, AKBuilt 1958 · S/N 34915N4816JMorten Derek J · Northwood, NDBuilt 1981 · S/N T18803768TN4817DWirt James · Goldsby, OKBuilt 1958 · S/N 34917N4819NSilva Robert · Davis, CABuilt 1979 · S/N 18267391N481CPBlue Water Aviation LLC · Oakman, ALBuilt 2008 · S/N 18282048N481DGrey Goose LLC · Wasilla, AKBuilt 1957 · S/N 50255N481HWilliams Stephen C · Georgetown, MEBuilt 1961 · S/N 185-0116N481JCollins Jason · Mansfield, OHBuilt 1977 · S/N 21061580N481PMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1977 · S/N U20603684N481QAdams Eddie · Senath, MOS/N 18053060N481TRBowen Tim S · Robstown, TXBuilt 1978 · S/N U20604383N481USalter 11x LLC · Duluth, MNS/N 18504438N4820SCalico Construction Inc · Kensington, MDBuilt 1979 · S/N R18201432N4821USouth Side Corp · Loomis, NEBuilt 1963 · S/N 205-0521N4822DRegistered aircraftBuilt 1958 · S/N 34922N4822NBalinski Stephen W · Lusby, MDBuilt 1979 · S/N 18267394N4824FWheeler Michael P · Declo, IDBuilt 1966 · S/N U206-0524N4825DHitec Construction Services Inc · Lincoln, CABuilt 1958 · S/N 34925N4825FLober Richard M · Bishop, CABuilt 1966 · S/N U206-0525N4825NBlue 79 LLC · Loogootee, INBuilt 1979 · S/N 18267397N4826DTurbine Training Center Inc · Manhattan, KSBuilt 1958 · S/N 34926N4827DWebber David A · Delta Junction, AKBuilt 1958 · S/N 34927N4827UHagen Rainer · Irving, TXBuilt 1979 · S/N U20605119N4828DNisbet William T · Driggs, IDBuilt 1958 · S/N 34928N4829NKcj Fly LLC · Fuquay Varina, NCBuilt 1979 · S/N 18267399N482CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282142N482CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282263N482TWT34 Mentor LLC · Saint Joseph, ILBuilt 2017 · S/N 18283006N4830NSimansky Daniel W Trustee · Van Nuys, CABuilt 1979 · S/N 18267400N4831DVogel Paul R · Valparaiso, INBuilt 1958 · S/N 34931N4831FWillis Rodney S · Wasilla, AKBuilt 1966 · S/N U206-0531N4832DM & D Adventures LLC · Ozark, MOS/N 34932N4832UBryant David DBA · Athens, TNBuilt 1963 · S/N 205-0532N4833DSmith Shayne A · Greenville, TXS/N 34933N4833NMegalith LLC · Belvidere, ILS/N 18267403N4834DGrismer Larry Trustee · Hemet, CABuilt 1958 · S/N 34934N4834SBuell Bay Co · Irvington, VABuilt 1979 · S/N R18201434
Back to AD 84-10-01 R1