Skip to content

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.

N4089MViens Ernest W · Eagle River, AKBuilt 1947 · S/N 12-2978 N408BWKough David M · Nashville, TNBuilt 2002 · S/N 60116 N408CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881119 N408CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282446 N408EAMagnell Gregory P Trustee · Vicksburg, MIBuilt 1998 · S/N 18280139 N408EPAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11439 N408EZKoester David P · Newport, ORS/N 709 N408FHStevens William C · Ashland, MTBuilt 2012 · S/N 2012131 N408FLSmith Benson H · Herington, KSBuilt 1971 · S/N 28-7125184 N408HCFarview Holdings LLC · San Francisco, CABuilt 2024 · S/N 1367 N408JMRobinson Wayne D · Highlands Ranch, COBuilt 2000 · S/N 80380 N408JNTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1966 · S/N 58 N408LBM & G Aircraft Management LLC · Englewood, COBuilt 2012 · S/N 172S11157 N408LTDecathlon LLC · Lincoln, NEBuilt 2025 · S/N 012 N408PBBaich Michael V · Bovey, MNBuilt 1979 · S/N 28-7911143 N408PTRegistered aircraftBuilt 1981 · S/N 1 N408TWWayne Terry · Belews Creek, NCBuilt 2024 · S/N JA699-7-23 N408ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881669 N408ZWLinett Michael J · Elsmere, DEBuilt 2019 · S/N 41724 N40903Boyer Aviation LLC · Kiel, WIBuilt 1973 · S/N 28-7415108 N40904Allred Klein Enterprise LLC · San Diego, CABuilt 1973 · S/N 28-7415109 N40905Martin James Christopher · South Jordan, UTBuilt 1973 · S/N 28R-7435140 N4090EAerodrome LLC · Louisville, KYBuilt 1977 · S/N 18-7809062 N4091PPaulay Sandor F · Kenmore, WABuilt 1959 · S/N 23-1570 N4091ZA G Sholton Co · Wasilla, AKBuilt 1964 · S/N 18-8109 N40925High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 28-7415112 N4092MSmith Dennis L · Carthage, NCFirst renewal noticeBuilt 1947 · S/N 12-2983 N40935International Air Services Inc Trustee · Carson City, NVBuilt 1941 · S/N 7603 N40936Aerial Sign North Inc · Lakewood, NJBuilt 1941 · S/N 7592 N40939Grog Holdings LLC · Dallas, TXBuilt 1973 · S/N 28-7425191 N4093PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1572 N4093XBartholomeo Daryl A · Cleveland, OKBuilt 1971 · S/N 5193 N40940Williams Richard S · Longview, TXBuilt 2009 · S/N TB-001 N40945Mount Eagle Inc · Alexander, ARBuilt 1974 · S/N 28-7405077 N4094MVaughn Charles M · Titusville, FLBuilt 1946 · S/N 12-3028 N4094PShelley Isaac R · Scottsville, VABuilt 1959 · S/N 23-1573 N40951Grant Constance R Trustee · Eaton, INBuilt 1973 · S/N 28-7425193 N40953Cws Capital Holdings LLC · Saint Petersburg, FLBuilt 1973 · S/N 28-7415118 N4095PTorell Pamela O · Port Saint Lucie, FLBuilt 1959 · S/N 23-1574 N4095ZBreidenbach Bros Inc · Iliff, COBuilt 1964 · S/N 18-8108 N40963Grant Matthew D · Alvord, TXBuilt 1974 · S/N 28-7415120 N40965Portsmouth Flying Club LLC · Epsom, NHBuilt 1973 · S/N 28-7415121 N40966Skytech Hc Ltd · Fredericksburg, OHBuilt 1973 · S/N 28-7415122 N40967Mcbroom Darrin · Des Moines, IABuilt 1973 · S/N 28R-7435146 N40969Papa Bravo LLC · Decatur, ALBuilt 1974 · S/N 28-7410052 N4096ESwiss John T · Anchorage, AKBuilt 1978 · S/N 18-7809064 N4096XFoster Robert L Jr · Chandler, OKBuilt 1970 · S/N 5196 N4096ZTurner Hal Eugene Jr · Tiburon, CAS/N 18-8110 N40972Terry Aaron D · Glendale, AZS/N 28-7425196 N40978Dodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 31-8152199

Back to AD 81-18-04 R2