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

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.

N700RWWhittington Rankin A Trustee · Lenoir, NCBuilt 1978 · S/N 18266323 N7014ESkinner Norman D · Osceola, IABuilt 1964 · S/N 21058334 N701DZSkydive Fargo Inc · West Fargo, NDFirst renewal noticeBuilt 1965 · S/N 18256501 N701FASkylane Flyers LLC · Fort Mill, SCBuilt 2002 · S/N 18281107 N701MDDel Mar Aviation LLC · Algona, IABuilt 1980 · S/N 21064007 N701PSLucky US LLC · Merrill, WIBuilt 1977 · S/N 21062339 N701SDRescue Ministry Corp · Haines City, FLBuilt 1980 · S/N R18201548 N7021QClasen David L · Big Bear Lake, CABuilt 1973 · S/N 18262016 N7022Golden Eagle Outfitters Inc · Delta Junction, AKBuilt 1961 · S/N 18051073 N7028SSkylane LLC · Salt Lake City, UTS/N 18265049 N702BDaly Moses M · Underhill, VTS/N U206-1279 N702CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281702 N702DZSkydive Fargo Inc · West Fargo, NDBuilt 1966 · S/N P206-0152 N702HPJoplin Flyers Inc · Joplin, MOFirst renewal noticeBuilt 1982 · S/N 18268167 N702SDVaughn Gregory T · Santa Fe, TXS/N R18200293 N702TCSykes Gregory P · Arlington, WAFirst renewal noticeBuilt 1976 · S/N 21061672 N7032QRegistration Pending · Oakwood, OHRegistration pendingBuilt 1976 · S/N U20603067 N7036UN7036u LLC · West Palm Beach, FLBuilt 1955 · S/N 31621 N7039SHotel Sierra LLC · Madison, WIBuilt 1976 · S/N 18265051 N703BSOne Grand Adventure LLC · Green Bay, WIS/N R18201930 N703CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281703 N703MMGuidry Kirby J Jr · Blanco, TXBuilt 2000 · S/N 18280760 N703ZSibert Gerald R · Tacoma, WABuilt 1971 · S/N 18260582 N7040SPro Plus Holdings LLC · Gillette, WYBuilt 1976 · S/N 18265052 N7044SNorthern Virginia Flying Club Inc · Aldie, VABuilt 1976 · S/N 18265053 N7045QDavidson Parker · Redding, CABuilt 1973 · S/N 18262021 N7046QRicken Kent · Boone, COBuilt 1973 · S/N 18262022 N7048HMuise Jason A · Windham, NHS/N 18265754 N7049HAir Bound Aviation LLC · Fairfield, NJBuilt 1981 · S/N 18267900 N704AMAmerican Resources Inc · Harlan, KYS/N 18265979 N704AVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 20608225 N704CPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283358 N70506Roesner Liselotte A · Hilton, NYBuilt 1973 · S/N U20602073 N70511Tanner Carlton · Coupland, TXBuilt 1968 · S/N 18259282 N70513Hummer Ernest · Bonner, MTBuilt 1968 · S/N 18259284 N70517Southern Aviation LLC · Griffin, GABuilt 1968 · S/N 18259285 N70521Gray John R · Cornville, AZBuilt 1968 · S/N 18259287 N70538Nordic Air LLC · Buffalo, MNS/N 18259293 N70560Blue Sky Flyers LLC · Toccoa, GAS/N 18259304 N70563Missouri-Stone Co · Cartwright, NDBuilt 1968 · S/N 18259305 N70565Langworthy Peter B · Warrensburg, MOBuilt 1968 · S/N 18259306 N70566Twin Otter International Ltd · Las Vegas, NVBuilt 1968 · S/N 18259307 N70570Miel Del Rio Grande Inc · Monte Vista, COBuilt 1973 · S/N U20602083 N70574Blue Sky Pilots Inc DBA · Salem, ORBuilt 1968 · S/N 18259310 N70582Goos Aviation LLC · Meridian, IDBuilt 1968 · S/N 18259312 N70591Fugleberg Richard H · Mayville, NDBuilt 1968 · S/N 18259315 N70594Non-Typical Airplanes LLC · Malad City, IDS/N U20602084 N70595Lung Aerial Group Inc · Tustin, CABuilt 1973 · S/N U20602085 N70598Routh Lucas R · Albert Lea, MNFirst renewal noticeBuilt 1973 · S/N U20602087 N705DBEbco Aviation Insurance LLC · New Bern, NCBuilt 2017 · S/N 18282432

Back to AD 84-10-01 R1