OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,733

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
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.

N44754Greenville Pickens Roundtrac LLC · Easley, SCBuilt 1974 · S/N 28R-7535003N4475JHilburn Brian · Philadephia, PABuilt 1967 · S/N 28-22891N4475PRamaswamy Gautam · Clearwater, FLBuilt 1961 · S/N 23-1997N4475RBrown Charles A · Portland, TXBuilt 1978 · S/N R18200604N4475TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250106N44761Henderson Gregory S · Saltsburg, PABuilt 1974 · S/N 28-7515025N44763Flying Peanuts LLC · Wilmington, DEBuilt 1974 · S/N 28-7505007N44764Hess Alex · American Fork, UTBuilt 1974 · S/N 28-7505008N4476EN4476e LLC · Saint Charles, MOBuilt 1978 · S/N 38-78A0627N4476VDirty Bird Helicopters LLC · Boerne, TXBuilt 2012 · S/N 4551N4476ZS And C Flying LLC · Pierre, SDS/N 18-8827N44771Benedict Kevin M · Lakeland, FLBuilt 1974 · S/N 28-7525003N44772Hanson Donald H · Bellevue, WABuilt 1974 · S/N 28-7515028N44773Nair Vihas G · Philadelphia, PABuilt 1974 · S/N 28-7515029N44775Heuerman Jordan D · Casey, ILBuilt 1974 · S/N 28-7515030N44777Delisi Carl V · Linden, MIS/N 28-7510004N4477ABrown Danny J · Skidmore, MOBuilt 1956 · S/N 18-4833N4477PAirknocker Inc · Wilmington, DEBuilt 1960 · S/N 25-253N44780Imler Jarrod M · Gallatin, TNBuilt 1975 · S/N 28-7510005N44782Alsup Jonathan S · Tok, AKBuilt 1974 · S/N 32-7500002N44786Flight Academy LLC · Van Nuys, CAS/N 28-7515032N44789Dzialo Matthew J · Pawtucket, RIBuilt 1974 · S/N 28-7505011N4478AOrth Henry J · Wasilla, AKBuilt 1956 · S/N 18-4835N4478JFly 500 LLC · Fort Pierce, FLBuilt 1967 · S/N 28-22894N4478TSchroder David A · Venice, FLBuilt 1972 · S/N 28-7205168N4478XWhite Raymond W · Montrose, MIBuilt 1975 · S/N 28-7615017N44790Spence William M · Naples, FLBuilt 1974 · S/N 28R-7535007N44792Ocean Air Inc · Eugene, ORBuilt 1974 · S/N 28-7515064N4479RUp And Up Aviation LLC · Magnolia, TXS/N 17263221N4479TSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1972 · S/N 28R-7235033N4479YKnutson Wayne R · Tioga, NDBuilt 1966 · S/N 25-4108N4479ZHardan Weston W · Palmer, AKBuilt 1969 · S/N 18-8834N447BAHc01 LLC · Vero Beach, FLBuilt 2013 · S/N 2263N447BBFerree William M · Stafford Springs, CTBuilt 2017 · S/N 71509N447BDRegistration Pending · Columbia, KYRegistration pendingBuilt 2009 · S/N 60103N447BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 4496581N447BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496606N447CFBleecker Lee M · Dousman, WIBuilt 1995 · S/N 0218N447CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282353N447CTHowell Aviation LLC · Orlando, FLS/N 38-82A0041N447ERSilver Express DBA · Miami, FLS/N 172S10221N447ESRegistered aircraftS/N 18280135N447GHorn Rodney L · Friendswood, TXBuilt 2008 · S/N 72825N447HHartz Paul · Lake Suzy, FLBuilt 2002 · S/N 169N447JCConner Jeff · Findlay, OHBuilt 2026 · S/N 41739N447KSPoletto Danny A · Great Falls, MTBuilt 1969 · S/N 28-25439N447MHKelsey Terry D · Guthrie, TXFirst renewal noticeBuilt 2006 · S/N 11193N447MKNorth Star Aviation Inc · Mankato, MNBuilt 2019 · S/N 4496459N447PJones Thomas C · Friendswood, TXS/N 108N447RCEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1995 · S/N 0205
Back to AD 81-18-04 R2