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.

N26278Bal-Air LLC · Boca Raton, FLBuilt 1977 · S/N AA5A0502 N2627CC And T Aviation LLC · Shreveport, LABuilt 1978 · S/N R18200180 N2627MN2627m LLC · Rehoboth Beach, DEBuilt 1988 · S/N 755M N2627NCartwright Josh D · Salem, MOBuilt 1988 · S/N 0756 N2627WDiamond Engineering & Service Co · Granger, INBuilt 1966 · S/N 3297 N26284Rupke Curtis · Winterville, NCS/N 7570 N2628GArsenault Donald S · Round Rock, TXBuilt 1967 · S/N 53 N2628PCraig Richard L · Sonoma, CAS/N 22-2965 N2628ZSipes Gary C · Livingston, TXBuilt 1988 · S/N 0773 N26292Qualitair LLC Trustee · MichelstadtBuilt 1977 · S/N AA5A0508 N26293Proclaim Aviation Ministries · Worthington, MNBuilt 1940 · S/N 7581 N26294Dennen Corey M · Troup, TXS/N AA5A0509 N26297Hunter Danny L · Gulfport, MSBuilt 1977 · S/N AA5A0510 N26298Champaign Sharon E · New Holstein, WIBuilt 1977 · S/N AA5A0511 N26299Ferraris Robert · Tinton Falls, NJBuilt 1977 · S/N AA5A0512 N2629VEyw Flying LLC · Key West, FLBuilt 1974 · S/N 177RG0635 N2629WHogan James C DBA · Cameron Park, CABuilt 1966 · S/N 970 N262ACLavelle Jeffrey · Kenmore, WABuilt 1996 · S/N 766-96 N262AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281187 N262ALDale County Sheriffs Office · Ozark, ALBuilt 1981 · S/N R18201836 N262AMChapman Kevin Joseph · Williston, NDBuilt 2004 · S/N 2262 N262CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881005 N262CLGiga Energy Inc · Buna, TXBuilt 2004 · S/N 18281497 N262CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283017 N262E349 Ez LLC · Yakima, WABuilt 1984 · S/N 262 N262EEHorizon Flights Corp · Henderson, NVBuilt 1973 · S/N 17261621 N262ERRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 17263854 N262ESBreshears Michael · San Antonio, TXBuilt 1986 · S/N 425 N262GCSlepica Michael · Oregon, WIS/N 32R-7985030 N262GGN262ggllc LLC · Reno, NVBuilt 1967 · S/N 28-10934 N262GRDr I T Help LLC · Cheyenne, WYBuilt 1996 · S/N 21387 N262LHNeo Helicopter Academy LLC · North Royalton, OHBuilt 2009 · S/N S1926 N262LNWave Shack Acquisitions LLC · Palm Coast, FLBuilt 2014 · S/N 001 N262MGordon Bruce · Marstons Mills, MABuilt 1976 · S/N 17268356 N262MJGillian Michael J · Batavia, ILBuilt 2001 · S/N 29 N262MTBurns Mark R · Streetsboro, OHBuilt 2016 · S/N 18282449 N262NDMoore Aviation Inc · Beaver Falls, PABuilt 1999 · S/N 2842061 N262NJJ2environmental LLC · Del Mar, CABuilt 2012 · S/N 41147 N262PDGritter Richard J · Catlett, VABuilt 1991 · S/N 01 N262PEPorter Randall L · Athol, IDBuilt 1971 · S/N 492 N262R262r LLC · Richland, WABuilt 1966 · S/N 28-21931 N262RMDisrud Roger G · Olathe, KSBuilt 2002 · S/N 80153 N262SASundance Airport LLC · Yukon, OKBuilt 1967 · S/N 28-4047 N262TBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCBuilt 1953 · S/N 18-2376 N262WYMoore Enterprises Leasing Inc · Indianapolis, INBuilt 2016 · S/N 3262 N262XPrice Scott K · Sparks, MDBuilt 1973 · S/N 28R-7335286 N26300Boyer Steven L · Wooster, OHBuilt 1977 · S/N AA5A0513 N26304Cobra Kai Inc · Wichita Falls, TXBuilt 1977 · S/N AA5A0522 N2630MMock Air LLC · Marion, INBuilt 1979 · S/N 17271166 N2630UShaka Skies LLC · Kihei, HIBuilt 1998 · S/N 17280568

Back to AD 81-18-04 R2