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.

N97046Falcon Aviation Inc · Farmington Hills, MIS/N 18266952 N97049Tepper Jeremy A · Vail, AZS/N 18266954 N9704ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 18268439 N9704GJohnsons Aero Ag Inc · Box Elder, SDBuilt 1971 · S/N 18052204 N97051White Stephen M · Tempe, AZBuilt 1979 · S/N 18266955 N97052Atnip James L · Cody, WYBuilt 1979 · S/N 18266956 N97058Whizbang Flyers LLC · Houghton Lake, MIBuilt 1979 · S/N 18266958 N9705BRovey James A · Troy, IDBuilt 1957 · S/N 50003 N9705SVandivier Calvin Leo · Navarre, FLBuilt 1997 · S/N 18280016 N9705ZDavis Bob F · Helena, MTBuilt 1960 · S/N 50800 N9706XEl Paso Aero Inc · El Paso, TXBuilt 1962 · S/N 21058006 N97071Heckathorn Chad W Trustee · Elk Point, SDBuilt 1979 · S/N 18266962 N97073Rodland Karin D · New Concord, OHBuilt 1979 · S/N 18266963 N97077Trail-Guides LLC · Sharpsburg, GAS/N 18266966 N9707GBurns Patrick · Carnation, WABuilt 1971 · S/N 18052207 N9707JTop Hand Inc · Laurel, MTBuilt 1981 · S/N T18803842T N97082N97082 LLC · Scottsdale, AZS/N 18266971 N97084Dockall Jesse A · Litchfield Park, AZBuilt 1979 · S/N 18266972 N97087Alpha Bravo LLC · Egan, LAS/N 18266973 N9708BBaxter Christopher V · Anchorage, AKBuilt 1957 · S/N 50006 N9708GDma Enterprises LLC · Fort Worth, TXBuilt 1971 · S/N 18052208 N97096Lacy Clay · Groveland, CABuilt 1979 · S/N 18266976 N97097Youngman David A · Boca Raton, FLBuilt 1979 · S/N 18266977 N97099Northwoods Air LLC · Orono, MEBuilt 1979 · S/N 18266978 N970CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281970 N970MRGlobal Aviation LLC · Grain Valley, MOS/N 21059904 N9710GThompson William G · Mattawa, WABuilt 1971 · S/N 18052210 N9711AJones Stanley A · Benkelman, NEBuilt 1969 · S/N 18260098 N9711GBurcham Robert A · Anchorage, AKBuilt 1971 · S/N 18052211 N9711ZT Skye LLC · Yakutat, AKBuilt 1982 · S/N U20606619 N97123Peak Investments LLC · Roanoke, VABuilt 1979 · S/N 18266984 N97127Sandquist Michael A · Molalla, ORBuilt 1979 · S/N 18266985 N9712BLafleur Kerry P · Fort Worth, TXBuilt 1957 · S/N 50010 N9712GReynolds Frederick A · Pilot Point, AKBuilt 1971 · S/N 18052212 N97133Niner 7133 LLC · Layton, UTBuilt 1979 · S/N 18266987 N9713GKochert Timothy B · Anchorage, AKBuilt 1971 · S/N 18052213 N97146Silver City Aviation LLC · Sterling, KSBuilt 1979 · S/N 18266991 N97148Cullen Kevin · Bethesda, MDBuilt 1979 · S/N 18266992 N9714XEtheredge William T IV · Texas City, TXBuilt 1962 · S/N 21058014 N97156Skaglin Michael S · White Lake, MIBuilt 1979 · S/N 18266996 N97157Oliver Blake H · Talbotton, GABuilt 1979 · S/N 18266997 N97159Quetzal Aviation Corp · Washington, DCBuilt 1979 · S/N 18266999 N9715GMonfore Mark A · Wasilla, AKS/N 18052215 N97160Foster Mark C Trustee · Carson City, NVBuilt 1979 · S/N 18267000 N9716BSelkirk Associates Inc · Wilmington, DEBuilt 1957 · S/N 50014 N9716XLowe Joshua T · Mount Baldy, CAS/N 21058016 N97170Connor Catherine E · Morgantown, WVBuilt 1979 · S/N 18267002 N97178Meador Rita R · Eldorado, TXS/N 18267006 N9717GBurley Mark A · North Pole, AKBuilt 1971 · S/N 18052217 N9717XEichner David K · Portland, ORBuilt 1962 · S/N 21058017

Back to AD 84-10-01 R1