Skip to content

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.

N169JABixby & Sons LLC · Vale, ORBuilt 1964 · S/N 18256004 N169KD182 Flight Corp · Bronx, NYBuilt 1979 · S/N 18267456 N169NMaxfield Douglas · Chico, CABuilt 1962 · S/N 18051138 N169PGHarty Joshua · Strasburg, COS/N T210-0423 N169PPOrtiz Peter · El Paso, TXBuilt 1985 · S/N 18268444 N169TFStewart Scott A · Anchorage, AKS/N 185-0383 N16AHendrix Aviation LLC · Benton, ARBuilt 1978 · S/N R18200405 N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101 N16CJRoyale Air Service Inc · Fort Myers, FLS/N U20602501 N16GBWester Lawrence Cale · Star, IDBuilt 1973 · S/N U20602075 N16GPDeckload Aviation LLC · Kodiak, AKS/N U20604467 N16HTAviation Specialties Unlimited Inc · Boise, IDBuilt 1964 · S/N 2060134 N16MSEnergy Transfer Aviation LLC · Spring, TXBuilt 1979 · S/N 18267267 N16ZAVisser Johannes Christoffel · Reno, NVBuilt 1980 · S/N 21063807 N1700CKrause Kade G · Jackson, MTBuilt 1953 · S/N 30400 N17011Saunders Aviation LLC · South Portland, MEBuilt 2007 · S/N 18282010 N1702CCork Dennis R · Soldotna, AKBuilt 1953 · S/N 30402 N1702RDaniel Boone Flying Club Inc · Booneville, MOBuilt 1978 · S/N R18200523 N1703MNesloney Thomas Jeffery · Hilltop Lakes, TXBuilt 1975 · S/N 18264417 N1704QOlfert Ronald W Trustee · Frazer, MTS/N 18257248 N1704UKuspuk School District · Aniak, AKBuilt 1975 · S/N 20700304 N17059N79107 LLC · Orrville, OHBuilt 1982 · S/N R18201915 N1705RCox Brian Allen · Pasadena, CABuilt 1978 · S/N R18200525 N1708CHaggard Roy A · Murrieta, CABuilt 1953 · S/N 30408 N1709CDmj Holdings LLC · Kalispell, MTBuilt 1953 · S/N 30409 N1709TBartolomei Thomas J · Flower Mound, TXBuilt 2005 · S/N 18281619 N170ACBrett Price Excavating Inc · Rigby, IDS/N 18266551 N1710CSmith Peter R · Lewistown, MTBuilt 1953 · S/N 30410 N1710GNational Test Pilot School · Mojave, CAS/N 18282011 N1711CNorthern Flyway LLC · Anchorage, AKBuilt 1953 · S/N 30411 N1711WBogaard Jeffery D · Kansas City, MOBuilt 1966 · S/N 18257108 N1712CGrant Douglas E Jr · Chubbuck, IDBuilt 1953 · S/N 30412 N1712SNorth Carolina Dept Of Enviroment & Natural Resour · Raleigh, NCBuilt 2005 · S/N 18281620 N17132Harvey Laurence C · Lincoln, NEBuilt 1982 · S/N R18201921 N1713CAir-Spacers Inc · Santa Monica, CABuilt 2007 · S/N 18282013 N1713RNevada General Enterprises Ltd · Reno, NVBuilt 1978 · S/N R18200530 N1714CMoreau Aviation LLC · Wasilla, AKS/N 30414 N1715CAerotrack Inc · Hemet, CABuilt 1953 · S/N 30415 N1716CReidenbach John S · Kenosha, WIBuilt 1953 · S/N 30416 N1716RRegistration Pending · Krum, TXRegistration pendingBuilt 1978 · S/N R18200531 N1716XBell Brian · Oakland, CABuilt 1975 · S/N 21060738 N1717XSay Plastics Inc · Jacksonville, TXBuilt 1967 · S/N T2100267 N1717YSeventeen Yankee LLC · Fort Lauderdale, FLBuilt 1979 · S/N U20605030 N17180Newby Adam M · Anchor Point, AKBuilt 1953 · S/N 30443 N171BCR Wesley Aviation LLC · Chandler, AZBuilt 1981 · S/N 64251 N171ESFenton Richard R Trustee · Mckinleyville, CABuilt 1972 · S/N 18260964 N171KSVida Vibrante LLC · San Juan, PRBuilt 1979 · S/N 21063167 N171MHEvolution Solid LLC · Salem, ORBuilt 1981 · S/N R182-01766 N171RMMckinney Mark · Meadowview, VABuilt 1972 · S/N U20601938 N171RSSeneque USA Inc · West Palm Beach, FLBuilt 1980 · S/N U20605558

Back to AD 84-10-01 R1