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.

N1747MMcmillan James D · Abilene, TXBuilt 1975 · S/N 18264425 N1747RFite Rodney Edward · San Lorenzo, CABuilt 1978 · S/N R18200544 N1748RNorthstar Holdings LLC · Anchorage, AKBuilt 1980 · S/N U20605438 N1748UIliamna Air Taxi Inc · Iliamna, AKBuilt 1976 · S/N 20700348 N1748ZRanz Douglas R · West Bloomfield, MIBuilt 1962 · S/N 205-0047 N1749UFreshwater Adventures Inc · Dillingham, AKBuilt 1976 · S/N 20700349 N174AAdkins Charles D · Apopka, FLBuilt 1957 · S/N 34535 N174GPLittle Terry J · New Port Richey, FLBuilt 1979 · S/N R18201136 N174HLarsen Kevin L · Firth, IDBuilt 1955 · S/N 31512 N174LAltitudes Aircraft Group LLC · Tampa, FLBuilt 1950 · S/N 7539 N1750URenfro Michael W · Bethel, AKBuilt 1976 · S/N 20700350 N1751CFeaga Charles C Jr · Abbot, MES/N 30451 N1751RB&E Flying LLC · Morse Bluff, NEBuilt 1978 · S/N R18200545 N1752CJarvis Jerry · Big Lake, AKS/N 30452 N1754USutton Aircraft Salvage LLC · Palmer, AKBuilt 1976 · S/N 20700354 N1754XWest Alabama Lime Co Inc · Livingston, ALBuilt 1975 · S/N 21060775 N1755CSutton Aircraft Salvage LLC · Palmer, AKBuilt 1953 · S/N 30455 N1755RMchugh Charles D · Gilbert, AZBuilt 1978 · S/N R18200547 N1756CGospel Ministries International Inc · Collegedale, TNBuilt 1953 · S/N 30456 N1756URude Daniel R · Leesbug, VABuilt 1982 · S/N 21064739 N1756VMtp Flyers · Riverhead, NYBuilt 2005 · S/N 18281626 N17572Valencia Technical Consulting LLC · Gig Harbor, WABuilt 2005 · S/N 18281628 N1757RKemna Barry J · Dallas, TXBuilt 1978 · S/N R18200548 N1758UBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 20700358 N175CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282337 N175MMHarden Jon R · Ijamsville, MDBuilt 1978 · S/N 18053032 N1760MCoggin Patric D · Fort Smith, ARBuilt 1975 · S/N 18264427 N1763MHaines Robert F · Carlsbad, CABuilt 1975 · S/N 18264429 N1763XRobins Nest Aviation LLC · Harrison, OHBuilt 1975 · S/N 21060784 N1764CRyan Michael · Gillette, WYS/N 30464 N1764XLeschber Larry · Hutto, TXBuilt 1975 · S/N 21060785 N1765MFlying Cow LLC · Syracuse, NYBuilt 1975 · S/N 18264430 N1765RPlane Pro Aviation LLC · Shelby, NCBuilt 1978 · S/N R18200553 N1766MN1776m LLC · Panama City, FLBuilt 1975 · S/N 18264431 N1767MAnderson Thomas C Trustee · Sun City West, AZBuilt 1975 · S/N 18264432 N176LLClear Above LLC · Haymarket, VABuilt 1975 · S/N 21061135 N176YCessna U206f Aviation LLC · Boise, IDS/N U206-03383 N1770XPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060791 N1771MGaley Matthew Blake · Greenwood, MSBuilt 1975 · S/N 18264433 N1773RAsher Robert P · Oregon City, ORBuilt 1978 · S/N R18200554 N1774CStol LLC · Fort Wayne, INBuilt 1953 · S/N 30474 N1774HPeacock Bruce M · Mendon, VTBuilt 1980 · S/N 18267507 N1777RKnur Ronald Glen · Elizabeth City, NCBuilt 1978 · S/N R18200555 N1778MSeitz David C · Gordonville, TXS/N 21061958 N1778UMission Aviation Fellowship · Nampa, IDS/N 20700378 N1779MBlagg Kevin · Dumas, ARBuilt 1975 · S/N 18264439 N177CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282338 N177URegistration Pending · Midvale, UTRegistration pendingBuilt 1949 · S/N 7433 N177WAnderson David R · Sycamore, ILBuilt 1950 · S/N 7642 N1780MCherri Stanley · Pearland, TXBuilt 1975 · S/N 18264440

Back to AD 84-10-01 R1