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.

N369ANJet Aircraft Inc Trustee · Wilmington, DEBuilt 2000 · S/N 18280696 N369BBRandigo LLC · Wilmington, DEFirst renewal noticeBuilt 1967 · S/N TD-713 N369BFPedersen Andrew T · Apex, NCS/N 3660 N369BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881769 N369CParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020223 N369CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12346 N369DADuan Ran · Bothell, WABuilt 2023 · S/N 172S13041 N369DMHoll Brian E · Chugiak, AKBuilt 1975 · S/N 830-75 N369DPFlying Monkey LLC · Wilmington, DEBuilt 2009 · S/N 82882 N369DSCross Douglas J · Yucaipa, CABuilt 1997 · S/N 369 N369ELErickson Logging Inc · Gig Harbor, WAFirst renewal noticeS/N 1590 N369ERTower Aviation Management LLC · Decatur, TXFirst renewal noticeS/N 172RG0062 N369FSOne Tango Mike LLC · Martinez, CABuilt 2005 · S/N 90810 N369GBStork 1 LLC · Green Cove Springs, FLBuilt 1981 · S/N 15285103 N369HOld Style Aircraft LLC · Ellsinore, MOS/N 863 N369JLFt Aviation LLC · Dyersburg, TNS/N 2531 N369JPWaddell Patrick G · Seattle, WABuilt 2003 · S/N 40.310 N369KCCarver Clarence K · Lutz, FLBuilt 2025 · S/N 60264 N369KGRegistered aircraftBuilt 1995 · S/N 23008C N369METvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 20608125 N369NEPeter Travis E · Evansville, WYBuilt 1979 · S/N 172RG0233 N369PPPositive Attitude Ia LLC · Gaithersburg, MDBuilt 1974 · S/N 17263099 N369QCHosking Aerobatics · Bountiful, UTFirst renewal noticeS/N 61P-0531-224 N369RPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N 369 N369RAShaffer Patricia G · Texarkana, TXBuilt 1971 · S/N 17259719 N369RJD & S Aviation LLC · Spring, TXBuilt 1979 · S/N 17273068 N369RNTurtle Air LLC · Sarasota, FLBuilt 2006 · S/N 5369 N369SPXin Han Aviation LLC · Helena, MTS/N 17262809 N369SRChopper Shots LLC · West Bath, MEBuilt 1989 · S/N 1017M N369SSEvolution Enterprises LLC · Wilmington, DEBuilt 2001 · S/N MW6009 N369TWChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9063 N369WOtter Mark E · Warrensburg, MOBuilt 1980 · S/N 920 N369WBSale Reported · Knoxville, TNSale reportedBuilt 1979 · S/N LG-1 N369WPLego Aviation LLC · Grimes, IABuilt 2025 · S/N 18283327 N369XHibbs Curtis M · Houston, TXBuilt 1995 · S/N 20754 N369XHFly Yawa Aviation LLC · Statesboro, GABuilt 2012 · S/N 3148 N36AFLewis Richard M Jr · Deltaville, VABuilt 1977 · S/N R18200104 N36AHHall Timothy L · Papillion, NEBuilt 1993 · S/N 20814 N36ALCuozzo Alfred F · Eagle Point, ORBuilt 2000 · S/N AD0198-RV8 N36BSBarnard Brian D · Tallahassee, FLBuilt 1990 · S/N 1012 N36CEHawkes Delray · Sequim, WABuilt 1982 · S/N 24-1321 N36CRRacer Aviation LLC · Moorestown, NJBuilt 2000 · S/N 278 N36DBWalsh Terence G · Fort Lauderdale, FLBuilt 1978 · S/N 28-7890441 N36DSUp And Up Aviation LLC · Spring, TXBuilt 1970 · S/N 17259145 N36DXObreiter Robert W Jr · Simi Valley, CABuilt 2017 · S/N 1 N36EHGerman Eric S · Imperial, NEBuilt 1977 · S/N 529 N36EJKessler Rafael · Alamogordo, NMBuilt 2007 · S/N 413-1936 N36ERSkytypers Inc DBA · Las Vegas, NVBuilt 1978 · S/N AA5B0897 N36FLGalloway Lyle R · Ashton, IDS/N 225 N36GGHoban Patrick · Collingswood, NJBuilt 1986 · S/N 483-H

Back to AD 81-18-04 R2