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

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.

N4793SArkansas Pilots For Christ Inc · Paragould, ARBuilt 1969 · S/N 32-1180 N47941Engineering Forensics Inc · Glen Burnie, MDS/N 28-7816167 N47943Louiewex Corp · Dover, DES/N 28-7890157 N47945Countee Roger Brendan · Los Angeles, CABuilt 1977 · S/N 28R-7837018 N4794LFerraro Henrik L · Grand Island, NYBuilt 1967 · S/N 28-4131 N4794YAir Kraft Spraying Inc · Timber Lake, SDBuilt 1968 · S/N 25-4572 N47953Mountain Aviation Associates LLC · Midland, TXBuilt 1977 · S/N 28-7816169 N47954Jennings James A · Fredericktown, OHS/N 28-7816170 N47955Southeastern Minnesota Flying Club Inc · Rochester, MNBuilt 1977 · S/N 28-7890159 N4795LN383j LLC · Henderson, NVBuilt 1967 · S/N 28-4132 N4795MMountain Air Inc · Quincy, CAFirst renewal noticeBuilt 1997 · S/N 11308 N4795TCammack Van R Jr · Willow Park, TXBuilt 1972 · S/N 28R-7235110 N4795YPiper 4795y Aviation Services LLC · Colorado Springs, COBuilt 1968 · S/N 25-4573 N47965Reid Brian M · Boise, IDS/N 28-7890156 N47968Grimes Mike · Yukon, OKBuilt 1977 · S/N 28-7816173 N47969Thomason Eric A · Georgetown, TXBuilt 1977 · S/N 28-7816174 N4796AThompson Muriel K · Eagle Pass, TXBuilt 1956 · S/N 22-3947 N4796VPittman Robert · Ocala, FLBuilt 1980 · S/N 172RG0381 N47971Five X Five Flight Inc · The Woodlands, TXBuilt 1977 · S/N 28-7890163 N4797SSmith Matthew · Seattle, WABuilt 1969 · S/N 32-1182 N47981Sabetha Flyers Inc · Sabetha, KSBuilt 1977 · S/N 28-7890164 N4798EClark Robert · Junction City, KSBuilt 1978 · S/N 17271663 N4798LThompson Michael · Stacy, MNS/N 28-4136 N4798SEller Donald B · Palmer, AKBuilt 1969 · S/N 32-1183 N4798THrv Holdings LLC · Camp Hill, PABuilt 1972 · S/N 28-7205196 N4798ZAnderson David J · Fridley, MNBuilt 1961 · S/N 22-8365 N47995Raab David A · York, PABuilt 1977 · S/N 28-7890168 N4799ANew England Aircraft Detailing LLC · Webster, MABuilt 1979 · S/N A1520893 N4799PPlayer Dennis · Union Bridge, MDBuilt 1960 · S/N 27-359 N4799SMiller Charles B · Pass Christian, MSBuilt 1969 · S/N 32-1184 N4799TSale Reported · Omaha, NESale reportedBuilt 1972 · S/N 28-7205197 N4799WHudson Kelsey L · Snohomish, WABuilt 1977 · S/N 14119 N4799ZRegistration Pending · Carefree, AZRegistration pendingBuilt 1961 · S/N 22-8366 N479ACVick Vernon A · Dublin, OHBuilt 1999 · S/N 427-99 N479BKTensas Taildraggers LLC · Saint Joseph, LABuilt 2017 · S/N 153 N479CNFlight World Inc · San Juan, PRBuilt 1975 · S/N 17266007 N479EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11601 N479FLImmell John A · Chillicothe, OHBuilt 1971 · S/N 28-7125285 N479JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020079 N479NTFlight World Inc · San Juan, PRBuilt 1975 · S/N 17265279 N479SHParker Helicopter LLC · Watsonville, CABuilt 2006 · S/N 4058 N47ACReabe Aircraft Improvement Inc · De Pere, WIBuilt 1974 · S/N 3200 N47AFL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281041 N47ASM D Ham LLC · Conover, NCFirst renewal noticeBuilt 1998 · S/N 21048C N47ATPutman William C · Bigfork, MTS/N 147 N47BBRogers Joseph O III · Fernandina Beach, FLBuilt 1960 · S/N 24-1889 N47BJMisunas Mark · Daytona Beach, FLBuilt 1974 · S/N 177RG0612 N47BLLade Burton G · Bemidji, MNBuilt 2010 · S/N 003 N47BNCavorite Aviation LLC · Lehi, UTBuilt 1995 · S/N 28-43020 N47CBBias Alexandru S · Soldotna, AKS/N 12-2781

Back to AD 81-18-04 R2