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.

N9208CKinzie Hon K · Anchorage, AKBuilt 1954 · S/N 31307 N9208GAdams Shane M · Jonesborough, TNBuilt 1971 · S/N 18260748 N9208TLund Philip Carl Trustee · Fort Mcdowell, AZBuilt 1960 · S/N 50708 N92098Valburg Bill J · Draper, SDBuilt 1969 · S/N 18260042 N92099Jiang Jacky · Riverside, CABuilt 1969 · S/N 18260043 N9209CTuckfield Brent M · Monroe, WAS/N 31308 N9209HUnited States Air Force Owner · Elmendorf Afb, AKBuilt 1981 · S/N 18267927 N9209TTop Hand Inc · Laurel, MTBuilt 1960 · S/N 50709 N920BWWilliams Rebecca J · Alto, NMBuilt 2001 · S/N 18280979 N920GGAbbott Air Inc · Hydro, OKBuilt 1976 · S/N 21061545 N920MAPerry Castonguay Farms Inc · Omega, OKBuilt 1999 · S/N 18280628 N920NCState Of North Carolina · Raleigh, NCBuilt 2000 · S/N 18280920 N920NWDavis Theodore T · Lake Oswego, ORBuilt 1977 · S/N 18265594 N920SBDream Cloud Aviation LLC · Saint Marys, PABuilt 1978 · S/N R18200444 N92106Reese Karl J · Salome, AZBuilt 1969 · S/N 18260047 N92112N92112 LLC · Litchfield Park, AZBuilt 1969 · S/N 18260049 N92114Schwantz Sharee M · Azle, TXBuilt 1969 · S/N 18260050 N92116Dickens Henry V · Morganton, NCS/N 18260051 N92119Albin Robert D · Santa Rosa, CABuilt 1969 · S/N 18260053 N9211TSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 50711 N9211XSalter 11x LLC · Duluth, MNS/N 18253611 N92120Westlund Jason Wade · Seattle, WABuilt 1969 · S/N 18260054 N92125Seemann James P · Dade City, FLFirst renewal noticeBuilt 1969 · S/N 18260055 N9212CMyers Kenneth O · Niskayuna, NYBuilt 1978 · S/N R18200445 N9212XNs Aviation Inc · Ottumwa, IABuilt 1961 · S/N 18253612 N9213CGriffith Thomas J · Watertown, MNBuilt 1955 · S/N 31312 N9213XChung Thomas · Stanwood, WABuilt 1961 · S/N 18253613 N92147Bielstein David P · Plainville, GABuilt 1969 · S/N 18260063 N9214CSchumacher Gregory L · Anchorage, AKS/N 31313 N9214GOwens Joseph F · Tallahassee, FLBuilt 1971 · S/N 18260754 N92150Pessolano Vincent F · Naples, FLBuilt 1969 · S/N 18260064 N92151Adiabatic Adventures LLC · Morrison, COBuilt 1969 · S/N 18260065 N92152Pank Thomas E · Walkersville, MDS/N 18260066 N92158Ackerman Jefferson P · Beaufort, SCBuilt 1969 · S/N 18260068 N9215CIrlbeck Joshua W · Northfield, MNBuilt 1954 · S/N 31314 N9216GComdess Company Inc · Seville, OHBuilt 1971 · S/N 18260756 N92172Fly Like An Eagle LLC · Springfield, MOBuilt 1969 · S/N 18260073 N92175Richards Joseph · Gardiner, NYBuilt 1969 · S/N 18260074 N9217GRegister Otis E · Rolla, MOBuilt 1971 · S/N 18260757 N9217RHunt Galen C · Bellevue, WABuilt 1984 · S/N U20606826 N92180Mahanti Robert L · Flagstaff, AZBuilt 1969 · S/N 18260075 N92183Desselle Trent · New Orleans, LAS/N 18260077 N92184Aviatrix Adventures LLC · Tallahassee, FLBuilt 1969 · S/N 18260078 N92187Med Eagle LLC · Folsom, CABuilt 1969 · S/N 18260079 N9218CArensmeyer Michael W · Longmont, COBuilt 1978 · S/N R18200448 N9218GTpec LLC · Madison, MSBuilt 1971 · S/N 18260758 N92190Rimkus Fisher · Rio Frio, TXBuilt 1969 · S/N 18260081 N92193Hendricks Alan M · Greenville, TXBuilt 1969 · S/N 18260082 N92198Hanson Steven Dale · Livermore, CABuilt 1969 · S/N 18260084 N9219COtt Tucker Kyle · Belgrade, MTBuilt 1955 · S/N 31318

Back to AD 84-10-01 R1