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.

N832CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281301 N832PMCunningham William R · Broken Arrow, OKS/N 18258824 N832TCFour Pines LLC · Grand Rapids, MNBuilt 2003 · S/N 18281269 N8330BSilver Creek Aviation Services · Fort Worth, TXBuilt 2011 · S/N 20608330 N8331ZProbasco Mitchell L · Floydada, TXBuilt 1963 · S/N 205-0331 N8332SFlyit LLC · Camas, WABuilt 1965 · S/N 18256432 N8334QVolatile Aero Ventures LLC · Boulder City, NVS/N U20603195 N8334SRecord John W · Apison, TNS/N 18256434 N8335ZLorentzen Aaron · Sterling, AKBuilt 1963 · S/N 205-0335 N8336SGroff Bradley Gene · Kingston, OKBuilt 1965 · S/N 18256436 N8338ZNistler Ben · Bozeman, MTBuilt 1963 · S/N 205-0338 N833CGParagon Air Group · Fort Worth, TXBuilt 2011 · S/N 20608333 N833CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281302 N833SATimmcke Alan E · Tampa, FLBuilt 2002 · S/N 18281133 N8340QFly8ma LLC · Big Lake, AKS/N U20603201 N8340ZInstant Equity Auto LLC · Boise, IDS/N 205-0340 N8342SSkydive Northstar LLC · Mankato, MNBuilt 1965 · S/N 18256442 N8343SMcgowan Jon G · Northfield, MABuilt 1965 · S/N 18256443 N8343ZBybee Don R · La Center, WABuilt 1963 · S/N 205-0343 N8344SDouble Nickel Recycling LLC · Perryville, MOS/N 18256444 N8344ZMccoy Dell K · Aurora, ILBuilt 1963 · S/N 205-0344 N8345QKatahdin Air Service Inc · Hermon, MEBuilt 1976 · S/N U20603206 N8345SOlsen H Peter Jr · Fallon, NVBuilt 1965 · S/N 18256445 N8346ZHerrick William L · Howell, MIBuilt 1963 · S/N 205-0346 N8347SShaffer Dyke T · Santa Rosa, CABuilt 1965 · S/N 18256447 N834CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281303 N834ZGroshel Joseph C · State College, PABuilt 1955 · S/N 32038 N8350SRegistration Pending · Wheatland, CARegistration pendingBuilt 1965 · S/N 18256450 N8352QUnited Indian Missions DBA · Tucson, AZBuilt 1976 · S/N U20603213 N8352SMacwilliamson Roger · Hollister, CABuilt 1965 · S/N 18256452 N8353ZMccoy Jesse Jacob · Cabot, ARBuilt 1963 · S/N 205-0353 N8354SNorthrop Kimberlei A · Spokane, WABuilt 1965 · S/N 18256454 N8355QDelta Pacific Northwest LLC · Anchorage, AKS/N U20603216 N8355SFayette Hawks Flying Club Inc · Somerville, TNBuilt 1965 · S/N 18256455 N8356SHirlinger Saylor John Trustee · Stevenson Ranch, CABuilt 1965 · S/N 18256456 N8357MPrinceton Soaring Assoc · Princeton, NJBuilt 1976 · S/N 18264594 N8358SStewart Bryan P · Carson City, NVBuilt 1965 · S/N 18256458 N835CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281304 N835MDMacconnell John · Deland, FLBuilt 1963 · S/N 18254759 N835TAHuber Gary · Bradenton, FLBuilt 1976 · S/N 18265019 N8361ZVining Eric · Lowell, ARS/N 205-0361 N8362ZCampbell Tyler A · Billings, MTBuilt 1963 · S/N 205-0362 N8363MWeatherford Ranches Support Services LLC · Arlington, ORBuilt 1976 · S/N 18264596 N8363SHellie Andrew Bryant · College Place, WAS/N 18256463 N8366QBesse Richard L · Wasilla, AKFirst renewal noticeBuilt 1976 · S/N U20603227 N8367EGergis Pierre · Brooklyn, NYBuilt 1974 · S/N 18263191 N8367ZMccole Kevin · Brookline, NHBuilt 1963 · S/N 205-0367 N8368QBrown Christopher · Grass Valley, CABuilt 1976 · S/N U20603229 N8368SKangas Gary J · Fairbanks, AKBuilt 1965 · S/N 18256468 N836CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281305

Back to AD 84-10-01 R1