Registered aircraft · 20,485

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N180WSBiloff Neil L · Milton Freewater, ORBuilt 1954 · S/N 31771 N180WWMyers Dale C · King Salmon, AKBuilt 1955 · S/N 31963 N180WYTorgerson Co LLC · Almena, WIBuilt 1955 · S/N 31437 N180XHigh Desert Land LLC · Rexburg, IDFirst renewal noticeBuilt 1959 · S/N 50485 N180XBChandler Christian J · Ashfield, MABuilt 1969 · S/N 18052008 N180XPAnders Jack H · Bend, ORBuilt 1956 · S/N 32494 N180XRBank Of Utah Trustee · Salt Lake City, UTBuilt 1954 · S/N 30743 N180XZGengenbach Joseph G · Livingston, TXBuilt 1964 · S/N 18051449 N180YKnudson Aviation LLC · Bozeman, MTBuilt 1962 · S/N 18051187 N180YHRobb Jon D · Alma, MIS/N 18051597 N180YPCrow Jack R · Bethel, AKBuilt 1964 · S/N 18051349 N180YSMontgomery Jeffrey · Lone Pine, CABuilt 1958 · S/N 51398 N180YYHastings Jamie · Vancouver, WAS/N 18052485 N180ZHenderson Ag Service Inc · Osceola, ARBuilt 1954 · S/N 30828 N180ZRLundell Don C · Los Altos, CABuilt 1955 · S/N 31662 N1810RMcdaniel Benjamin G III · Birmingham, ALBuilt 1978 · S/N R18200569 N1810ZRanzway Corp · Seattle, WABuilt 1962 · S/N 2050010 N1811XAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1964 · S/N 18255911 N1812QLiv2fly LLC · Grand Junction, COBuilt 1975 · S/N U20602936 N1812XDavid Glen E · Ash Fork, AZS/N 18255912 N1814FAlpine Cable And Construction Inc · Grand Junction, COBuilt 1965 · S/N 21058714 N1815HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 21061148 N1816FMalcom Scott O · Toledo, WABuilt 1965 · S/N 21058716 N1816JWakefield Aircraft LLC · Cooperstown, NDS/N 182-68574 N1817RLfg Properties LLC · Portage, MIS/N R18200571 N1817XSale Reported · Roseville, MNSale reported, pending cancellationBuilt 1965 · S/N 18255917 N1818Fulton Ricky L · Alex, OKS/N 18051551 N18182Samaha Fadi · Point Roberts, WABuilt 1975 · S/N 18263913 N1818AMaas Nancy C · Redding, CABuilt 1978 · S/N 18266532 N1818RSideline Services LLC · Pearland, TXBuilt 1978 · S/N R18200572 N1819XGrant Steven T · Sellers, SCBuilt 1964 · S/N 18255919 N181ATNazario Rafael · Delray Beach, FLBuilt 1973 · S/N 18262686 N181CPEighty1 Aviation LLC · Canton, GABuilt 1964 · S/N 18255766 N181CSElkhorn Valley Trucks II LLC · Fremont, NEBuilt 2024 · S/N 18283280 N181DHWinkler Jeffery L · Brush, COBuilt 1964 · S/N 206-0220 N181EWoodhead Matthew E Trustee · Reno, NVBuilt 1979 · S/N 18267304 N181JBBarrows Grayson J · Mcminnville, ORBuilt 1963 · S/N 18051329 N181JMMccloy John S · Lakeland, FLBuilt 1953 · S/N 30145 N181NWitt Robert A · Anchorage, AKBuilt 1956 · S/N 32416 N181PKPacific Mission Aviation · Hagatna, GUFirst renewal noticeS/N U20606158 N181RBBeltz Richard R · Lehighton, PABuilt 1956 · S/N 32712 N181RCWheeler Douglas N Trustee · Santa Fe, NMBuilt 1978 · S/N 18052982 N181RPCain Jeffrey B · Godley, TXBuilt 1981 · S/N 18053180 N181SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 20608192 N181STWagontrainer LLC · Kalispell, MTBuilt 1954 · S/N 30997 N181TXAddie-Air Inc · Bridgeport, TXBuilt 1981 · S/N U20606408 N181UKauffman Daniel C · Spring Grove, PABuilt 1981 · S/N 18268135 N181XLHis Wings Air Service Inc · Hyder, AKBuilt 1966 · S/N 18051670 N1820KBergstrom Aircraft Inc · Pasco, WABuilt 1975 · S/N 182-64092 N1820ZStaats Douglas E · Anchorage, AKBuilt 1962 · S/N 205-0020

Back to AD 84-10-01 R1