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.

N22905Yokota Flight Training Center · Apo, APBuilt 1974 · S/N 17264078 N2290AOrtega Aviation Services LLC · Wichita, KSBuilt 2005 · S/N 172S9959 N2290NKalika Kelly · Collinsville, ILBuilt 1971 · S/N 28-7105136 N2290QEno James C · Amherst, VABuilt 1977 · S/N 28-7725192 N2290TKnobloch Eric D · Green Cove Springs, FLFirst renewal noticeBuilt 1971 · S/N 28-7110022 N2290UVan Surdam John R · Seneca, SCBuilt 1966 · S/N 461 N2290YHerren Roger L · Clayton, ILBuilt 1967 · S/N 17700090 N2291CForty Four Fifteen LLC · Reno, NVBuilt 2005 · S/N 172S9962 N2291EDv Aviation Inc · Brainerd, MNBuilt 1978 · S/N 17271224 N2291HCommand Aviation · Bellingham, WABuilt 1978 · S/N 28-7816176 N2291PNice Flight LLC · Medford, ORBuilt 1957 · S/N 23-902 N2291UHines Scott C · Fort Worth, TXBuilt 1966 · S/N 462 N2291YWyatt Gary D · Sun City West, AZBuilt 1967 · S/N 17700091 N2292MShymkewich Dale G · Arlington, VABuilt 1977 · S/N 28R-7837081 N2292TRegistration Pending · Waverly, IARegistration pendingBuilt 1971 · S/N 28-7125640 N2292YJess Lawrence A · Menomonie, WIBuilt 1967 · S/N 17700092 N2293MFines Aviation #1 LLC · Fargo, NDBuilt 1977 · S/N 28R-7837082 N2293PGaston Stephen · Saint James City, FLBuilt 1957 · S/N 23-905 N2294AWeber Jacob · Homer, AKBuilt 1952 · S/N 22-679 N2294QSouth Florida Helicopters Inc · Indiantown, FLS/N 28R-7737033 N2294RSeeliger Jeremy E · Pasco, WABuilt 1978 · S/N R18200584 N2294YHeathfield William T · Plymouth, MIFirst renewal noticeS/N 17700094 N22954Wiermaa Jordan T · Lemoore, CABuilt 1994 · S/N 2985 N2295TAhs Aero LLC · Leo, INBuilt 1971 · S/N 28-7125641 N2295YHutto Azel James III · Lexington, SCBuilt 1967 · S/N 17700095 N22964Straight Flight Aviation LLC · Goliad, TXS/N 17264079 N2296NMacsdea LLC · Van Nuys, CABuilt 2005 · S/N 172S9967 N2296PTarrant County College · Fort Worth, TXBuilt 1957 · S/N 23-908 N2296TRegistered aircraftS/N R18200021 N2296XGleichauf Andrew N · Beloit, WIBuilt 1985 · S/N 0516 N2296ZPrevost Dustin · Alpena, MIBuilt 1978 · S/N 28-7816116 N2297SRocketjet LLC · Incline Village, NVS/N R18201328 N2297YKomulainen Daryl B · Clarksville, TNBuilt 1967 · S/N 17700097 N2298TT C Rocket LLC · Traverse City, MIBuilt 1977 · S/N R18200023 N2298WGoli Aviation LLC · Raleigh, NCBuilt 2005 · S/N 172S9968 N2299BEximious Flying Club Inc · Ferndale, MIBuilt 1977 · S/N 14169 N2299DCheri Lee Inc · Kulpmont, PABuilt 1977 · S/N 14230 N2299PMoeller Wendell L · Porter, TXBuilt 1957 · S/N 23-884 N229AASkyview Aviation LLC · Benton, KYBuilt 1967 · S/N TD-683 N229ABMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881539 N229ANCalifornia In Nice Inc · San Jose, CABuilt 1982 · S/N 17275587 N229APBrown Jeffrey L · San Luis Obispo, CABuilt 1977 · S/N 296/24-08 N229BParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020204 N229BADavila Associates · Dorado, PRBuilt 1975 · S/N 17265585 N229BBKidd Clifford L · Monahans, TXBuilt 1978 · S/N 466-79 N229CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283263 N229CHPollux Aviation Ltd · Wasilla, AKBuilt 2004 · S/N 10271 N229CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282293 N229DKKoerkenmeier James J · Carlyle, ILBuilt 1979 · S/N 15283544 N229DMWisconsin Aviation Inc · Watertown, WIBuilt 1977 · S/N 28-7890246

Back to AD 81-18-04 R2