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.

N191KBudd William M · St Simons Island, GABuilt 1946 · S/N 252 N191MPate Earl G · Hickory, NCBuilt 1992 · S/N 20109 N191NDMoore Aviation Inc · Beaver Falls, PABuilt 1989 · S/N 4495003 N191PALa Mooneytte LLC · Seabrook, SCBuilt 1964 · S/N 248 N191PCBad Attitude LLC · Lisbon, OHBuilt 2002 · S/N 896-2002 N191PFDunston Douglas E · Saint Paul, MNBuilt 2010 · S/N 90474 N191PSRegistration Pending · El Dorado Springs, MORegistration pendingBuilt 1994 · S/N 996 N191RLOpen Air Properties LLC · Jonesboro, ARS/N 14575 N191SBRasch Hellmut G · Tomball, TXBuilt 1999 · S/N 24417 N191SDCrockard Scott M · Oregon City, ORBuilt 2018 · S/N 90927 N191SHHutton Stephen · Madison, MSBuilt 1968 · S/N 17257232 N191SSRoberts Anthony Curtis · Dallas, TXBuilt 1998 · S/N 3165 N191SWFletcher Joseph E · Enid, OKBuilt 1999 · S/N 237 N191WWLichtscheidl Ted J · Forest Lake, MNBuilt 1972 · S/N 17260840 N191XRosendahl Paul O · Sangar, TXS/N 129 N1920CVanjara Gufran U · San Ramon, CABuilt 1964 · S/N 2686 N1920FChristensen Dean G · Elk Grove, CABuilt 1979 · S/N 17273012 N1920LAverill William B · Lacombe, LABuilt 1976 · S/N MB-792 N1920WWilfert Frederick · Springfield, VABuilt 1973 · S/N MB-579 N1921Koons Zachary K · Clinton, ILBuilt 1993 · S/N 20580 N1921FState Of Iowa · Iowa City, IABuilt 1979 · S/N 17273013 N1922LGassi Vito · Levittown, NYBuilt 1976 · S/N M-1819 N1922PNey N Marshall · Kapaau, HIS/N 22-2673 N1922QLendor Jason C · Chicago, ILBuilt 1972 · S/N 177RG0322 N1922VRogers Randall J · Newalla, OKBuilt 1974 · S/N 17263796 N1922YDurso Joseph M Jr · Mesa, AZBuilt 1964 · S/N 217 N19234Sharkey William Patrick · Walla Walla, WABuilt 1976 · S/N 17702563 N1923FAtlanta Air Academy LLC · Kennesaw, GABuilt 1980 · S/N 17273015 N1923HGardner Christopher M · Mankato, MNBuilt 1977 · S/N 28-7725168 N1923QHansen Eric P Trustee · Arlington, WABuilt 1973 · S/N 177RG0323 N1923RUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 1217-2024 N1923YHyde Joe G · San Angelo, TXBuilt 1964 · S/N 218 N19245Immel Justin Harrison · Minonk, ILBuilt 1976 · S/N 17702564 N1924HSkyjiro Forge Corp · Arcadia, CABuilt 1977 · S/N 28-7725169 N1924YHull Thomas · Midland, TXS/N 219 N1925QReagan Amber J · Mcalester, OKBuilt 1973 · S/N 177RG0325 N1925YMapes Peter B · Oscoda, MIBuilt 1964 · S/N 220 N1926FUnited Flying Club Inc · Belmont, CABuilt 1979 · S/N 17273017 N1926GJaju Aviation Inc · Abilene, TXBuilt 1974 · S/N 1026-74 N1926PHoudek Dennis E · Roseburg, ORBuilt 1955 · S/N 22-2677 N1926REmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2025 · S/N 172S13436 N1926WSengstock Frank W · Traverse City, MIBuilt 1973 · S/N MB-587 N1926YRoss Dustin · Georgetown, TXBuilt 1964 · S/N 221 N19274Jennings Lisa Nicole · Atlanta, GABuilt 1976 · S/N 17702566 N1927AHigh Wind Aviation Services LLC · Ludlow, VTBuilt 1952 · S/N 18-1762 N1927FSanders Herman G · Baldwyn, MSBuilt 1979 · S/N 17273018 N1927HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 28R-7737017 N1927LCarrillo Isaias D · Wasilla, AKBuilt 1976 · S/N MB-796 N1927WAltitude Aviation Services LLC · Mountain Home, IDBuilt 1973 · S/N MB-609 N1928FJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17273019

Back to AD 81-18-04 R2