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.

N1309WSanford Mark J · Ithaca, NYBuilt 1963 · S/N 197 N1309ZReady Aim Flyer LLC · New Castle, DEBuilt 1961 · S/N TD-463 N130ACBilco Air LLC · Danville, ILBuilt 1992 · S/N 663-92 N130AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496578 N130BBHatfield Derik L · Mesa, AZBuilt 1979 · S/N 0013 N130BNJch Aviation LLC · Midlothian, TXS/N 20110 N130BRWilcox Charles R · Discovery Bay, CABuilt 2005 · S/N 2920 N130BYCabe Robert D · San Antonio, TXBuilt 1999 · S/N 2 N130BZEvans Robert G · Choctaw, OKBuilt 2002 · S/N 21316 N130CFFlying C Leasing Ltd · Wilmington, DEBuilt 1977 · S/N 15279509 N130DBRolfe Daniel W · Elsie, MIS/N 90-12-001 N130DGDixie Aviation LLC · Pelham, ALBuilt 1972 · S/N 28R-7235127 N130DPPlane@Work LLC · Blaine, MNBuilt 1987 · S/N 003 N130EOshinuga Anthony A · Valley Center, CABuilt 1940 · S/N 1029 N130ERSale Reported · Freeburg, PASale reportedS/N 1511 N130GHBose Tamal · Tucson, AZBuilt 1965 · S/N 32-124 N130GWBruckner Peter J · Rochester, NHBuilt 1975 · S/N AA50707 N130GYRobinson Stewart · San Jacinto, CABuilt 1993 · S/N 2239 N130JAHagele Aviation LLC · Hillsboro, ORBuilt 2002 · S/N 172S9165 N130JMRegistration Pending · Tampa, FLRegistration pendingBuilt 1982 · S/N 28-8390036 N130KSouthern Aircraft Consultancy Inc Trustee · NorfolkRegistration ineffective or invalidBuilt 1978 · S/N 32R-7885109 N130KWClemente Daniel L · Manheim, PABuilt 2014 · S/N 90301 N130MEPetersens Marine Services Corp · Ridge, NYBuilt 2000 · S/N 18280686 N130MMMighty Mike LLC · Maysville, KYBuilt 1964 · S/N 30-550 N130MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2019 · S/N 4496477 N130PJLindholm Dow W · Masury, OHS/N 21572 N130PMMccurry Terry D · Greenwood, SCBuilt 2010 · S/N 22894 N130RNPrewitt Blake S · Prescott, AZS/N 20275 N130RRAllbritten Jeffrey P · Winder, GAS/N 2841264 N130SRLimitless Aviation And Adventures LLC · Tomball, TXBuilt 1994 · S/N 1642 N130TLynch Machining LLC · North Vernon, INBuilt 2003 · S/N 2844104 N130THDelage Jeffrey R · Biddeford, MEBuilt 1977 · S/N AA5A0398 N130TWAlkire Richard P · Dayton, OHBuilt 1991 · S/N 130 N130VUSwords Kyle · New Albany, MSBuilt 1975 · S/N 180-75 N130WLBlake Larry Q · Cleveland, GABuilt 1986 · S/N 130 N130YDBoyd William E Jr · Clifton Forge, VAFirst renewal noticeBuilt 2020 · S/N 41154 N130YSBuntin David P · Bethpage, TNBuilt 2011 · S/N 81209 N130YYMatejka Jeff · Maple, NCBuilt 2000 · S/N 21873 N130ZKrueger Mark A · Anchorage, AKBuilt 2001 · S/N 01 N131Ekstrand Marshall · Lake Stevens, WABuilt 1972 · S/N AA1B-0050 N13100Ruttenberg Barbara A · Lexington, KYBuilt 1973 · S/N 17262494 N13101North Hollywood Optimist Club Youth · Van Nuys, CABuilt 1973 · S/N 17262495 N13104Erley Robert B · Kirkland, WABuilt 1973 · S/N 17262498 N13108Registered aircraftBuilt 1976 · S/N 17702398 N13109Illinois Valley Flying Club · Peru, ILBuilt 1973 · S/N 17262503 N1310JRock Nh Services LLC · Alpine, TXS/N 310 N1310KVector Aviation LLC · Mentor, OHBuilt 1976 · S/N 28-7790216 N1310UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020247 N13115Kkmjj LLC · South Lyon, MIBuilt 1973 · S/N 17262507 N13117Mccullough James R · Newville, PABuilt 1973 · S/N 17262509

Back to AD 81-18-04 R2