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.

N1226CFortine Joseph A · Adin, CABuilt 1953 · S/N 22-1031 N1226FSnoopys Group Inc · Westerly, RIBuilt 1979 · S/N 17272978 N1226JMores Glenn S · Boxford, MABuilt 1974 · S/N 226 N1226TLinde Glenn F Jr · Juneau, WIBuilt 1972 · S/N 28-7205269 N1226UAirborne LLC · Wilmington, DEBuilt 1976 · S/N 17266922 N1227CMccall John L · Arlington, TXS/N 22-1034 N1227TStieper David Paul · Forest Lake, MNBuilt 1972 · S/N 28R-7235241 N1227UKelly William W · Springfield, ORBuilt 1976 · S/N 17266923 N1227XVan Hoosen Ronald L · Goldsby, OKBuilt 1963 · S/N 198 N1228REcko Air LLC · Springfield, MOBuilt 1989 · S/N 2841266 N1228UBig Sky Aviation LLC · Glenmora, LABuilt 1976 · S/N 17266924 N1229Fritzinger Thomas A · Maidens, VAS/N 1112 N12290Read Andrea · Austin, TXFirst renewal noticeBuilt 1973 · S/N 17261912 N12291Cisek Jason M · Westfield, MABuilt 1973 · S/N 17261913 N1229TPiper Electric Inc · Deer Park, NYBuilt 1972 · S/N 34-7250267 N1229UMcdonald Air Services LLC · Saint Johns, MIBuilt 1976 · S/N 17266925 N1229WScott George H · Springdale, ARBuilt 2000 · S/N 5258 N122AACnt Aviation LLC · Lake Tapps, WABuilt 2006 · S/N 11228 N122ADRegistered aircraftBuilt 2005 · S/N 81308 N122AKBarker Paul II · Rainbow City, ALBuilt 1991 · S/N 2028 N122BCChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12540 N122BPDiggins Charles J · Middleboro, MABuilt 1997 · S/N 22912 N122BRHollon Blake D · Douglas, WYBuilt 1958 · S/N TD-65 N122CFSouthwest Aviation Specialties LLC · Tulsa, OKS/N 15282778 N122CPFlorida Seaplanes LLC · Altamonte Springs, FLBuilt 2001 · S/N 18064C N122CWWentz Mark T · Milpitas, CAS/N 058 N122DDBeacon Hill Leasing LLC · Plymouth, MIBuilt 1977 · S/N 27-7754120 N122DTFine Point Aviation LLC · Carrollton, GABuilt 2000 · S/N 18280908 N122EAHumpal Nathan A · San Antonio, TXBuilt 2003 · S/N 60553 N122EZLawley Frederick Ellsworth III · Castro Valley, CAS/N 1297 N122GPEide Michael C · Severn, MDBuilt 2006 · S/N DM0206 N122HSafeline Aviation LLC · Apache Junction, AZBuilt 1999 · S/N 1274-99 N122HSMarbury Sherri E · Jackson, TNBuilt 1965 · S/N 28-2377 N122JAChase James P · Waco, TXBuilt 2025 · S/N 18283320 N122JDGrasshopper Aviation LLC · Hockley, TXBuilt 2000 · S/N 1301-2000 N122KCRomero Garcia Moises · Park City, UTBuilt 2003 · S/N 2105-L N122KPPeterson Keith D · Nevada City, CABuilt 2002 · S/N PETERSON-2 N122KRRutkowski Kurt A · Cresson, TXBuilt 1999 · S/N 2360 N122KYSeminole Flying & Soaring Inc · Clermont, FLBuilt 1968 · S/N 25-4576 N122MCShouk Aviation LLC · Waverly, OHBuilt 2007 · S/N 2844133 N122MJHyper Flight Inc · Seattle, WABuilt 1977 · S/N 17270043 N122MLLutz Michael A · Findlay, OHBuilt 2000 · S/N 645 N122MWWalker Kyle E · Lawrence, KSBuilt 1979 · S/N R18201276 N122NAGilded Gull Aviation LLC · Middletown, RIBuilt 1981 · S/N 28-8216068 N122PLSlip Stream Aviation Inc · Fort Mill, SCBuilt 2001 · S/N 3265 N122PMFrench Benjamen M · Dillon, MTBuilt 2025 · S/N 001 N122PPStout Andy · Livingston, TXBuilt 1990 · S/N 526 N122RFDaniels Ronald C · Poughkeepsie, NYS/N 3397 N122SGTanz LLC · Helena, MTBuilt 2004 · S/N 80094 N122SSGrain Belt Aviation LLC · Malcolm, NEBuilt 1975 · S/N 17264842

Back to AD 81-18-04 R2