Registered aircraft · 81,728

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.

N253BLewis Donald L · Brant Lake, NYBuilt 1957 · S/N 13 N253CAJtv Enterprises LLC · Painesville, OHBuilt 1977 · S/N 339-77 N253CCL-Bird LLC · Hood River, ORBuilt 2012 · S/N CC18-0055 N253CEElwell Charles W Jr · Destin, FLBuilt 2017 · S/N 70915 N253DCD & M Aviation Inc · Amelia, OHS/N 2053 N253EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13310 N253ERFreeman Joshua A · Platteville, COBuilt 1978 · S/N R18200723 N253JAYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 28020034 N253LPLazo Aitor · Irving, TXBuilt 2023 · S/N 92286 N253MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881445 N253NShay Aviation LLC · Aurora, COBuilt 2020 · S/N 41999 N253PAlan Negrin Aviation Services LLC · Kirkland, WABuilt 2013 · S/N 3027 N253PRRenaud Paul D · Tenafly, NJBuilt 2012 · S/N 40686 N253RAReynolds Darryl G · Wills Point, TXBuilt 1981 · S/N 17274790 N253RVWard Jeffrey K · Kennesaw, GABuilt 2009 · S/N 40253 N253SWBatts David · Lyons, COBuilt 1965 · S/N 28-2328 N253TPLeblanc John David · Deland, FLFirst renewal noticeBuilt 1987 · S/N 253 N253TSAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13470 N253WMLambert Timothy Allen Jr · Burleson, TXBuilt 1964 · S/N 28-2026 N253WPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2000 · S/N 18280743 N253WYMj & Rj LLC · Middletown, DEBuilt 2015 · S/N 3253 N254Russell Dale Christopher · Sierra Vista, AZBuilt 1978 · S/N AA5B0970 N25408Thompson David J · Pemberton, NJBuilt 1977 · S/N 15280637 N2540ASlaton James E · Minot Afb, NDS/N 22-837 N2540CSpeidel Jake P · Carmel, CABuilt 1978 · S/N 38-79A0222 N2540FMcguires Flying Service LLC · Obion, TNBuilt 1965 · S/N 96 N2540PReed Michael D · Parsons, KSBuilt 1955 · S/N 22-2903 N2540QAmt Aero Inc · Massapequa, NYBuilt 1977 · S/N 28-7790404 N25410Smith Ira · Henderson, NVBuilt 1980 · S/N 38-80A0166 N25413Dreamair Aviation Inc · Boca Raton, FLBuilt 1977 · S/N 15280641 N25416Mikes Aircraft Shop Inc · Corpus Christi, TXBuilt 1977 · S/N 15280643 N2541SLanning Danny E · Alzada, MTBuilt 1979 · S/N 18-7909156 N25426American Aviation Inc · Brooksville, FLBuilt 1977 · S/N 15280651 N2542MHudson Joseph M · Holly Springs, NCBuilt 1946 · S/N 12-1031 N2542WYoder Enos D · Goshen, INBuilt 1985 · S/N 32R-8613001 N2542ZGreenway Jonathan J · Frederick, MDBuilt 1977 · S/N 344-77 N25430G And M Aircraft Inc · Wheatridge, COBuilt 1977 · S/N 15280654 N2543URegistered aircraftBuilt 1979 · S/N 28-8090055 N2543ZSchindler Jason D · Oneill, NES/N 345-77 N2544MDeaton Mark · Gig Harbor, WAS/N 12-1033 N2544PCoonfield Russell Adam · Fayetteville, ARBuilt 1955 · S/N 22-2907 N2544SSunrise Adventures LLC · Stillwater, MNBuilt 1979 · S/N 18-7909155 N2545CDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496324 N2545MCopenhaver Patrick J · Enumclaw, WABuilt 1946 · S/N 12-931 N2545PMatter Steven S · Joliet, ILFirst renewal noticeBuilt 1955 · S/N 22-2908 N2545UMcmahon Patrick S · San Antonio, TXBuilt 1979 · S/N 28-8016032 N2545WRegistration Pending · Vienna, OHRegistration pendingBuilt 1974 · S/N MC-242 N25467Reynolds Financial Inc · Tyler, TXBuilt 1977 · S/N 15280636 N25469Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280675 N2546CRaby Byrd J · Normandy, TNBuilt 1954 · S/N 26190

Back to AD 81-18-04 R2