Skip to content

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.

N860XWiebelhaus John J · Strasburg, COBuilt 1965 · S/N 18256096 N86102Arrigo Aviation LLC · Erie, COBuilt 1973 · S/N 18261912 N8610TMusser Craig A · Linden, PABuilt 1960 · S/N 52510 N8611XWilliams John R · Boise, IDBuilt 1961 · S/N 18051011 N8613TDorough Luke L · Anchorage, AKBuilt 1960 · S/N 52513 N8614THodgdon Theodore A · Danbury, CTBuilt 1960 · S/N 52514 N8614XPolhemus Christopher · Carmichaels, PABuilt 1961 · S/N 18051014 N86167Jonsplain LLC · San Angelo, TXBuilt 1973 · S/N 18261916 N86168Mmm Aviation LLC · Scottsdale, AZBuilt 1973 · S/N 18261917 N8616TSpung Cameron · Ranchos De Taos, NMS/N 52516 N8617TBrunson Aviation LLC · Little Elm, TXBuilt 1960 · S/N 52517 N8617XLayton Kelly · Bountiful, UTBuilt 1961 · S/N 18051017 N8619XCummings Jim L · Delta Junction, AKBuilt 1961 · S/N 18051019 N861BABarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280101 N861CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 18283343 N861SFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 18281438 N86227Kantorowicz Tammy · Great Falls, MTBuilt 1973 · S/N 18261919 N8622TBothell Eric L · Center, COBuilt 1960 · S/N 52522 N8623ZHauze John W · San Antonio, TXBuilt 1967 · S/N P206-0423 N8625TChisum Lance A · Boise, IDBuilt 1960 · S/N 52525 N86261Odle Scott Thomas · Redmond, WABuilt 1973 · S/N 18261922 N8626THibbert Walter W · Otto, WYBuilt 1960 · S/N 52526 N8627TRegistered aircraftBuilt 1960 · S/N 52527 N86289Hudec John S · Crown Point, INBuilt 1973 · S/N 18261923 N8628TR&D Aviation Holdings LLC · Bellville, TXBuilt 1960 · S/N 52528 N8628ZSaddler Susan J · Dayton, OHBuilt 1967 · S/N P206-0428 N8629TWoodworth Mark P · Golden, COBuilt 1960 · S/N 52529 N862CBFolk Tom M · Puyallup, WABuilt 1963 · S/N 205-0254 N862PZBuntzman Gabriel F · Bowling Green, KYBuilt 2000 · S/N 18280762 N8630THensley Steven Lee Jr Trustee · Scappoose, ORBuilt 1960 · S/N 52530 N8630ZAlaska Village Missions · Homer, AKBuilt 1967 · S/N P206-0430 N8632TLucky Resin Works LLC · Bend, ORBuilt 1960 · S/N 52532 N8632ZTate Roger · Redlands, CAS/N P206-0432 N86354White Billy C · Crestview, FLBuilt 1973 · S/N 18261928 N8635ZLipper Stephen W · Griffin, GAFirst renewal noticeBuilt 1967 · S/N P206-0435 N8637THundo Air LLC · Kalispell, MTBuilt 1960 · S/N 52537 N8638ZEichman David A · Topeka, KSBuilt 1967 · S/N P206-0438 N8640TSkydive Florida Keys Inc · Summerland Key, FLBuilt 1960 · S/N 52540 N86438Walleman Benjamin · Macomb, MIBuilt 1973 · S/N 18261933 N8643TStofer William · Warsaw, INS/N 52543 N8643ZVitatoe Industries Inc · Chillicothe, OHBuilt 1967 · S/N P206-0443 N8644ZMasters Mission · Nenana, AKBuilt 1967 · S/N P206-0444 N86450Butte Flying Club Inc · Chico, CABuilt 1973 · S/N 18261937 N8645TLaplante Bruce E · Vilonia, ARS/N 34790 N8646QPoe Asphalt Paving Inc · Lewiston, IDBuilt 1976 · S/N U20603462 N8647QTechnical Applications & Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603463 N8647TJones Wallace F · Waterford, MES/N 52547 N8649TJarosak Peter J · Valparaiso, INBuilt 1959 · S/N 52549 N864CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281854 N8650ZBarry Russell L · Fort Mohave, AZBuilt 1967 · S/N P206-0450

Back to AD 84-10-01 R1