Registered aircraft · 40,473

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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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.

N702BSTwo Bravo Sierra LLC · Auburn, CABuilt 2004 · S/N 1369-2004 N702DCTaylor Denise DBA · Lincoln, CABuilt 2002 · S/N 70296 N702GTsiouklas Aviation Inc · Dunedin, FLBuilt 1968 · S/N 17256919 N702JWisdom Murrel Wade · Nashville, ARS/N 90726 N702RASmtm Holdings Inc · Wilmington, DEBuilt 1974 · S/N 28-7415475 N702XLeonard Steven E · Wichita, KSBuilt 1995 · S/N 20311 N7030PMartens And Wyatt Air Service LLC · North Platte, NES/N 24-2177 N7030RAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1966 · S/N 28-21727 N7031ASmith Helicopters Inc · Cotulla, TXBuilt 1998 · S/N 2892 N7031BMason Crosby H · Zebulon, NCBuilt 1956 · S/N 22-4282 N7031CWestern New York Flying Club Inc · Bowmansville, NYBuilt 1975 · S/N 28-7690051 N7031WEarl Hittle Aero Inc · Greenville, OHBuilt 1962 · S/N 28-713 N70323Sky Equity LLC · Woodbury, MNBuilt 1976 · S/N 17267200 N7032BNetherby Richard J · Wake Forest, NCBuilt 1956 · S/N 22-4283 N7032MProbst John D · Del Norte, COBuilt 1993 · S/N 20024 N7032WFleming William P · Tomah, WIBuilt 1962 · S/N 28-715 N7033FNaugler Winsor III · Fort Washington, PABuilt 1976 · S/N 28-7725084 N7033WRegistered aircraftN-number assigned, not yet registeredS/N 28-716 N70340Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267203 N7034GFat Tyre Flyers LLC · Moses Lake, WABuilt 1969 · S/N 17258734 N7034QTesch David P · Pardeeville, WIBuilt 1971 · S/N 17260334 N7034RMacallen Chemical Inc · Monroe, LABuilt 1966 · S/N 28-21731 N7034WCooke Riley O · Bridger, MTBuilt 1962 · S/N 28-717 N7035DWall Quinton · Clearfield, UTBuilt 1957 · S/N 22-4929 N7035GWilkening Owen A · Gardena, CABuilt 2003 · S/N 22216 N7035QEarly Bird Aviation LLC · Phoenix, AZBuilt 1971 · S/N 17260335 N7035WJerome Jeffrey A · Conneaut Lake, PABuilt 1962 · S/N 28-718 N7036DLoch Paul M · Miramar, FLBuilt 1957 · S/N 22-4934 N7036FLa Vigne Henry A · Hercules, CABuilt 1976 · S/N 28-7715192 N7036PPumphrey Vickie E · Devine, TXBuilt 1960 · S/N 24-2183 N7036WArizona Flying Pigs LLC · Flagstaff, AZBuilt 1962 · S/N 28-719 N70376Sawyer Gregory T · Olga, WABuilt 1976 · S/N 17267206 N70378Vertol Systems Company Inc · Destin, FLBuilt 1976 · S/N 17267207 N7037DRegistration Pending · Eagle River, AKRegistration pendingBuilt 1957 · S/N 22-4932 N7037GN7037g Inc · Newark, DEBuilt 1969 · S/N 17258737 N7037QJohnson Joe N · Smithville, TNBuilt 1971 · S/N 17260337 N7037RJames Jerome A · Sioux Falls, SDBuilt 1966 · S/N 28-21734 N70380Mindy Ltd LLC · Muscatine, IABuilt 1976 · S/N 17267208 N70386Johnson Ben A · Gainesboro, TNS/N 17267209 N7038BRogers Wayne D · Bellingham, WABuilt 1956 · S/N 22-4289 N7038DHager Terry L · Texhoma, OKBuilt 1957 · S/N 22-4933 N7038FFly With US LLC · Seminole, ALBuilt 1976 · S/N 28-7715193 N7038QSchenone William M · Mattituck, NYBuilt 1971 · S/N 17260338 N7038RElite Aircraft Services LLC · Pierce City, MOBuilt 1966 · S/N 28-21735 N7038TNostdahl Robert W · Bottineau, NDBuilt 1961 · S/N 56331 N70392Gateway Flying Club Inc · Blaine, MNBuilt 1976 · S/N 17267211 N703CAFlying Penguin Aviation LLC · Atlanta, GAS/N 28-8116225 N703CBBailey Brian J · Barre, VTS/N 18-7709073 N703EADerrick Engineering Inc · Louisville, KYBuilt 1973 · S/N 28-7405036 N703ESTyler William R · Thomaston, MEBuilt 1978 · S/N 18-7809185

Back to AD 80-04-03 R2