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.

N43448Warrior Partners LLC · Delphi, INBuilt 1974 · S/N 28-7415495 N43449Blue Sky B&Rd LLC · Heber City, UTBuilt 1974 · S/N 28-7405195 N4344AMccarthy James L · Anchorage, AKBuilt 1956 · S/N 22-3700 N4344PAbele Benjamin · Lexington, NCBuilt 1984 · S/N 28-8490051 N4344TSpiegel Carl E · Waterford, CTBuilt 1971 · S/N 28-7205146 N4344ZLindley Douglas R · Nantucket, MABuilt 1968 · S/N 18-8662 N43455Siskiyou Aero LLC · Ashland, ORBuilt 1984 · S/N 28-8416055 N43456Parker Air LLC · Mobile, ALBuilt 1974 · S/N 28-7415499 N4345BHamilton Justin M · Knightsen, CABuilt 1984 · S/N 28-8416057 N4345CAeroservice Aft Corp · Miami, FLS/N 28-8416059 N4345GG & M Aircraft Inc · Wheat Ridge, COBuilt 1984 · S/N 28-8416061 N4345JSkinner Gary L · Winchester, OHS/N 28-22721 N4345QNeptune Aviation Services Inc DBA · Missoula, MTBuilt 1971 · S/N 17260245 N4345ZSimonson Daniel J · Loring, MTS/N 18-8663 N43460Seals Wiley · Suitland, MDS/N 28-7415501 N4346ADeakyne Carl · Rehoboth Beach, DEBuilt 1956 · S/N 22-3702 N4346DLane Community College · Eugene, ORBuilt 1984 · S/N 28-8416111 N4346FBohne Geoffrey C · Poway, CABuilt 1976 · S/N 28-7715022 N4346JVelthuis Remintyn · Fontana, CABuilt 1967 · S/N 28-22723 N4346QCorrado Christian Blake · South Point, OHBuilt 1971 · S/N 17260246 N4346RFlyhnz LLC · Oxford, NCBuilt 1974 · S/N 17263097 N4347DAviation Flight Services Inc · Cumming, GABuilt 1984 · S/N 28-8416081 N4347GPurdue Pilots Inc · West Lafayette, INBuilt 1984 · S/N 28-8416062 N4347HKillian Regina · Prosper, TXBuilt 1984 · S/N 28-8416063 N4347KRegistration Pending · Augusta, KSRegistration pendingBuilt 1984 · S/N 28-8416064 N43488Ravotti Air LLC · Leechburg, PABuilt 1974 · S/N 28-7415507 N4348FRegistered aircraftBuilt 1976 · S/N 28-7790018 N4348QStehouwer Todd J · Kentwood, MIBuilt 1992 · S/N 20771 N4348ZWilliams Reid G · Cantwell, AKBuilt 1968 · S/N 18-8645 N43493Henderson James A · Flomaton, ALBuilt 1974 · S/N 28-7415508 N4349FStriegel Jory D · Washington, DCS/N 28-7790019 N4349LParker Air LLC · Mobile, ALBuilt 1984 · S/N 28-8416068 N4349RVaughan James · Meansville, GABuilt 1974 · S/N 17263100 N4349TJrh Avgroup Inc · Satellite Beach, FLBuilt 1972 · S/N 28-7205147 N4349XElon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28-7515447 N4349YSpence Willard J · Davin, WVBuilt 1984 · S/N 28-8416071 N434DSFranseen Steven R · Northglenn, COBuilt 1996 · S/N 266 N434FLPerkins Jeffrey E · Grand Prairie, TXBuilt 1971 · S/N 28-7125220 N434JVClark Nathaniel T · Duncanville, TXBuilt 1966 · S/N 28-3646 N434PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496064 N434RVRudolph Richard W · Fort Worth, TXBuilt 2001 · S/N 60434 N434WPZimmerman Justin W · Palmer, AKBuilt 1968 · S/N 28-5071 N43507Washington Joseph D · Springfield, ILBuilt 1974 · S/N 28-7415512 N4350RB2 West Corp · Winona, MNBuilt 1974 · S/N 17263101 N4350WHochbrueckner Timothy W · Mineola, NYBuilt 1974 · S/N MC-272 N4350ZBenning Gary R · Blue Grass, IABuilt 1968 · S/N 18-8667 N43511Freedom Development Corporation LLC · Rock Hill, SCBuilt 1974 · S/N 28-7405201 N4351QJohnson James Benjamin · Rosharon, TXBuilt 1971 · S/N 17260251 N4351RVertol Systems Co Inc · Destin, FLBuilt 1974 · S/N 17263102 N4352ABrito Angelo M · Dillingham, AKS/N 22-3708

Back to AD 80-04-03 R2