Skip to content

Registered aircraft · 40,472

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.

N21374Stratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263938 N2137JAdverse Yaw LLC · Milford, CTBuilt 1978 · S/N 28-7916205 N2137TWatson Jay C · Midland, TXBuilt 1971 · S/N 28-7105160 N21389Registration Pending · Waldo, WIRegistration pendingBuilt 1974 · S/N 17263942 N2138PRedwood Barry Lindon · Forest, VABuilt 1956 · S/N 23-729 N2139JHotung Lisa M · Amherst, NYBuilt 1978 · S/N 28-7990220 N2139WRegistration Pending · Lake Worth, FLRegistration pendingBuilt 1974 · S/N M-1509 N213AMNorton Cole R · Marion, IAS/N 559-73 N213CBSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496147 N213MBNational Tax Relief Inc · Riverside, CAS/N 17702282 N21403Bering Capital LLC · Anchorage, AKBuilt 1974 · S/N 17263944 N2140JHardin County Aviation LLC · Kountze, TXBuilt 1975 · S/N 17265018 N2140RStidham Stephen A · North Pole, AKBuilt 1989 · S/N 01 N2140TCupples Thomas Joseph · San Marcos, CABuilt 1971 · S/N 287105162 N2140VSidhu Harish · Anaheim, CABuilt 1979 · S/N 28-7990340 N2140WAbbott Bruce E · Seal Beach, CABuilt 1974 · S/N M-1513 N2140YNorcal Flight Club · Vacaville, CABuilt 1979 · S/N 28-7916372 N21411Piper Partners · Coventry, CTBuilt 1978 · S/N 28-7990044 N21412Long Island Aviators LLC · Seaford, NYBuilt 1978 · S/N 28-7990045 N2141JRegistered aircraftBuilt 1978 · S/N 28-7990221 N2141PElliott David E · Peyton, COBuilt 1956 · S/N 23-734 N2141RM5:16 Ventures LLC · Brush Prairie, WABuilt 1979 · S/N 28-7990302 N2141WMeyer Carl F Jr · Eagan, MNBuilt 1974 · S/N M-1514 N2142RFieldhouse Warren W · Ocala, FLBuilt 1969 · S/N 28-5469 N2142XAnvab Inc DBA · Concord, NHBuilt 1979 · S/N 28R-7918089 N2143AUniversal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 44-7995085 N2143TRahim Shamim Inc · Jacksonville, NCBuilt 1971 · S/N 28-7125454 N2143YBk Aviation Services LLC · Graford, TXBuilt 1979 · S/N 28-7916357 N21441Paris Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916040 N21442Ducote Randal J · Parker, COBuilt 1978 · S/N 28-7990048 N21443Compton James R · Boise, IDBuilt 1978 · S/N 28-7990049 N21446Ham Todd O · Opdyke, ILBuilt 1974 · S/N 17263946 N2144THilds Marine Service Inc · Pasadena, MDBuilt 1971 · S/N 28-7105166 N2144WHansen Kenneth L · Kimballton, IABuilt 1979 · S/N 28-7916331 N21455Drewett Edward A · Many, LABuilt 1974 · S/N 17263950 N2145FSmith Jeffrey D · Hamilton, GAFirst renewal noticeBuilt 1972 · S/N AA5-0017 N2146TBreitfelder Nicholas A · Durango, IABuilt 1971 · S/N 28-7125546 N2147GAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 28-7916178 N2147TSchavone Loren A · Fullerton, CABuilt 1971 · S/N 28-7125547 N2147WMeyer Ronnie G · Sidney, NEBuilt 1974 · S/N M-1520 N21481Houston Christopher T · Webster, NYBuilt 1978 · S/N 28-7916044 N21485Dipzinski Victor L · Clio, MIFirst renewal noticeBuilt 1974 · S/N 17263956 N21489D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7990050 N2148FRegistration Pending · Wilmington, DERegistration pendingBuilt 1978 · S/N 44-7995157 N2148ZMalburg Phillip E · Holland, MIBuilt 1979 · S/N 28-7916378 N214APikago LLC · Moreno Valley, CABuilt 1978 · S/N 17270830 N214AALewis University · Romeoville, ILS/N 28-4735 N214ACRicard Carter J · Albany, MNBuilt 2000 · S/N 1305-2000 N214BWKansas Farm & Ranch Inc · Seneca, KSBuilt 1994 · S/N 1202-94 N214CMeister Curtis E · Plover, WIBuilt 1998 · S/N 1430

Back to AD 80-04-03 R2