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.

N422NPGarvin Honi J Trustee · Monument, COBuilt 2007 · S/N 23103C N422PRicmar Aviation LLC · Lewes, DEBuilt 2007 · S/N 3232065 N422RMMoore Aviation Inc · Beaver Falls, PAS/N 2843526 N422RVMachin Geoffrey C · Friday Harbor, WABuilt 1998 · S/N 21422 N422SHelfrick Jr Edward W · Elysburg, PABuilt 2006 · S/N 2059 N422SCAg Air Squadron One LLC · Saint Joseph, ILBuilt 1967 · S/N 28R-30022 N422SHSig Aero LLC · Lewes, DEBuilt 2019 · S/N 18283090 N422TTTravland Christopher L · Austin, TXBuilt 1978 · S/N R18200221 N422USParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020125 N422WCWilliams Wade M · Wasilla, AKBuilt 2020 · S/N 001 N422WFRoberts Wayne T · Spring Lake, MIBuilt 1946 · S/N 12-2520 N422WGWilliams Sara J · Kendallville, INBuilt 1980 · S/N 28-8016341 N422WHAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2000 · S/N 0795 N423Shafer Robert T · Grosse Ile, MIBuilt 1978 · S/N AA5B0986 N4230HHonolulu Helicopter Tours Inc · Honolulu, HIBuilt 2013 · S/N 2323 N4230JPleasant Valley Aviation Inc · Bellefonte, PABuilt 1966 · S/N 28-22579 N4230QAir Castles LLC · Ozark, ALBuilt 1971 · S/N 17260130 N4230ZBishop Mike · Rifle, COBuilt 1966 · S/N 18-8456 N42312Swinehart Frank E · Lock Haven, PABuilt 1995 · S/N 773 N4231JBielusiak Stanley J · Dartmouth, MABuilt 1967 · S/N 28-22580 N4231MHarloff David F · Lehigh Acres, FLBuilt 1947 · S/N 12-3129 N4231TInternational Air Services Inc Trustee · Carson City, NVS/N 172S12370 N42321Olson Richard Allen · Weatherford, TXBuilt 2018 · S/N 3275 N4232FSekel David A · San Diego, CABuilt 1976 · S/N 28-7725005 N4232HHupp Garrett · Sunbury, PABuilt 1978 · S/N 24-0671 N4232JN4232j LLC · Waialua, HIS/N 28-22581 N4232MHardy Willard H Jr · Lincolnville, MEBuilt 1947 · S/N 12-3128 N4232TDgap LLC · Niles, OHBuilt 1971 · S/N 28-7210005 N4233CFons William M · Oconomowoc, WIBuilt 1992 · S/N 3161 N4233MJordan Lee · Dickinson, TXBuilt 1947 · S/N 12-3177 N4233QWoods John B · Anchorage, AKBuilt 1971 · S/N 17260133 N4233TSmith Michael L · Lakeland, FLBuilt 1982 · S/N 186 N4233ZThompson Lee B · Anchorage, AKBuilt 1966 · S/N 18-8459 N4234HKacprzak Dominik · Kingwood, TXBuilt 1978 · S/N 24-0673 N4234JHomerun Horizons LLC · Weatherford, TXBuilt 1967 · S/N 28-22585 N4234QFarr Everett L III · Bensalem, PABuilt 1971 · S/N 17260134 N4234TParsons Donald Jr · Crumpler, NCBuilt 1971 · S/N 28-7205109 N4234ZLueking Clyde F · Holdrege, NEBuilt 1966 · S/N 18-8460 N42358Bakker Margaret E Trustee · Petaluma, CABuilt 1974 · S/N 28-7425314 N4235HJunker Gregory G · Cincinnati, OHBuilt 1978 · S/N 24-0676 N4235JBarrett Kevin M · Pittsburg, TXBuilt 1967 · S/N 28-22586 N4235RWustman Charles Dryer · Westerly, RIBuilt 1999 · S/N 25033C N42361Lima 001 LLC · Muscatine, IABuilt 1974 · S/N 17264171 N42362Francis Ellis H Jr · South Hill, VABuilt 1952 · S/N 22-799 N42363Harrison Kent B · Grass Valley, CABuilt 1974 · S/N 28-7415389 N4236HMakar Michael J · Anchorage, AKBuilt 1948 · S/N 14-39 N4236MLehman Robert J · Marissa, ILS/N 12-3132 N4236ZMinnehan Joseph T · Joplin, MTBuilt 1966 · S/N 18-8462 N4237HHolden Daniel N · Anacortes, WABuilt 1948 · S/N 14-40 N4237JMoppert Stephen Kyler · Madison, MSS/N 28-22589

Back to AD 81-18-04 R2