Registered aircraft · 81,720

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

N1714TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12050 N1715TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12051 N1715YPacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7654096 N1716AJacobs Dennis D · North Loup, NEBuilt 1952 · S/N 22-462 N1716JNess Brian · Wasilla, AKBuilt 1968 · S/N 28-24128 N1716PJones Gary L · Kerrville, TXBuilt 1954 · S/N 22-2506 N1716RRegistration Pending · Krum, TXRegistration pendingBuilt 1978 · S/N R18200531 N1716TStratus Business Development LLC · Nashua, NHBuilt 1970 · S/N 28-7125030 N1717Nelson Jeffrey V · Westfield, INBuilt 1981 · S/N 5431521 N17172Tohidi Karen A · North Las Vegas, NVBuilt 1976 · S/N 17702508 N17173Dunbar Michael C · Cedar Falls, IABuilt 1976 · S/N 17702509 N17177Dawn Patrol Flying Club · Northville, MIBuilt 1976 · S/N 17702510 N1717ARound Engine Aero · Nashville, MIS/N 22-466 N1717EN2893e LLC · Reno, NVBuilt 1978 · S/N 17270962 N1717LGkd Corp · Lakewood, WABuilt 2000 · S/N 27-0289 N17186Dubreuil Jean Pierre · Skyland, NCBuilt 1976 · S/N 17702513 N17187Cloud Chasers Inc · Albert Lea, MNBuilt 1976 · S/N 17702514 N17189Mangold Property Management Inc · Monterey, CABuilt 1976 · S/N 17702516 N1718PMorris Christian A · Hood River, ORBuilt 1954 · S/N 22-2508 N171ABMcwilliams Russell S · Flower Mound, TXBuilt 2003 · S/N 81642 N171BHHeinitz Brian A Trustee · Henderson, NVBuilt 1997 · S/N 171 N171CAAircraft Parts Store LLC · Jacksonville, FLBuilt 2002 · S/N 4496131 N171CCSale Reported · Xxx, OKSale reportedBuilt 2016 · S/N 12435 N171CKMcmullen Kelly A · Sun Lakes, AZBuilt 2016 · S/N 40866 N171CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12332 N171CRLaniape LLC · Fort Walton Beach, FLBuilt 2007 · S/N 1053-2007 N171DGTraver Larry L · Sturgis, SDBuilt 1977 · S/N 12410031 N171DHOul LLC · Hermon, MES/N 757 N171DLGibson Aviation LLC · Chandler, AZBuilt 2007 · S/N 3158 N171DSDelaware State University · Dover, DEBuilt 2019 · S/N 1021 N171EMagerstadt David E · Rhome, TXBuilt 1970 · S/N 0-1 N171EJRegistration Pending · Murphys, CARegistration pendingBuilt 2007 · S/N 25061 N171EPAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841209 N171GSMccormick Gregory W · Athens, ALBuilt 1980 · S/N 8014C N171HHLrh Equipment LLC · Pendleton, ORBuilt 1988 · S/N 758 N171JBAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1968 · S/N 28R-30756 N171KTYoder Dennis H · Huntingdon, PABuilt 2009 · S/N 71428 N171MCOrloff Kenneth L · Groveland, CABuilt 2015 · S/N 1001 N171MEPatriot Leasing LLC · Franklin, TNBuilt 2000 · S/N 172S8460 N171MHEvolution Solid LLC · Salem, ORBuilt 1981 · S/N R182-01766 N171MLBruey William P · Santa Monica, CABuilt 1998 · S/N 171 N171MMModer Michael T · New Holstein, WIBuilt 1986 · S/N 1826-L N171RACirrus Aviation Inc · Sarasota, FLBuilt 1999 · S/N 172S8237 N171SFStratusfire LLC · St Charles, ILBuilt 2005 · S/N 40.494 N171SKHuddleston Edward · Oaktown, INBuilt 1980 · S/N 17273857 N171SPState Of Iowa - Iowa State Patrol · Des Moines, IABuilt 2007 · S/N 18281977 N171STDkg Motorized Conveyances Inc · Beaverton, ORBuilt 2000 · S/N 18280703 N171TGarrett Wayne · Guntersville, ALBuilt 2025 · S/N 527-2025 N171TLHickey Timothy J · Montrose, IAS/N 721 N171TPPropst Terry L · Festus, MOBuilt 2023 · S/N 92310

Back to AD 81-18-04 R2