Skip to content

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.

N45141T45141 LLC · Orange, CABuilt 1978 · S/N AA5B1006 N4514AJones N Robert II · Indianapolis, INBuilt 1978 · S/N AA5B0998 N4514BNiemann Professionals P A · Melbourne Beach, FLS/N AA5B0999 N4514FBy The Grace Of God LLC · Miami, FLBuilt 1978 · S/N AA5B1000 N4514NAbc Flying Club Inc · West Mifflin, PABuilt 1978 · S/N AA5B1003 N4514VTorelli Bruce L · Memphis, TNBuilt 1978 · S/N AA5B1005 N4515DTucker Gary · Youngsville, LABuilt 1978 · S/N AA5B1009 N4515LBegich Michael James · Brea, CABuilt 1978 · S/N AA5B1010 N4515NAbsarokee Investment LLC · Billings, MTBuilt 1978 · S/N AA5B1011 N4515TSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2002 · S/N 4496115 N4515UHendrix William A · Flagstaff, AZBuilt 1978 · S/N AA5B1012 N45161Tonry Roger D · Los Angeles, CABuilt 1978 · S/N AA5B1024 N4516NRegistration Pending · Carlsbad, CARegistration pendingBuilt 1978 · S/N AA5B-1018 N4516TAir Time LLC · Newport, RIBuilt 1978 · S/N AA5B1020 N45175Hale Leland E · Warrington, PABuilt 1978 · S/N AA5B1036 N4517AShepherd Joseph Gary · Sharpsburg, GABuilt 1956 · S/N 22-3823 N4517NHosch Stephen R · Louisville, KYBuilt 1978 · S/N AA5B1030 N4517QMarburger James H · Phoenix, AZBuilt 1978 · S/N AA5B1033 N4517RGilbert Zachary · Jekyll Island, GAS/N 28-21218 N4517TTate Levi W · Saint George, UTBuilt 1972 · S/N 28-7205177 N45187Hill Samuel D · Dover, DEBuilt 1978 · S/N AA5B0803 N4518AJensen Dustin C · Santa Clara, UTS/N 22-3824 N4518BSmoke Seen LLC · Farmingdale, NYBuilt 1978 · S/N AA5B1038 N4518ERegistered aircraftBuilt 1978 · S/N AA5B1039 N4518KBrush Creek Farmhouse LLC · Valparaiso, INBuilt 1978 · S/N AA5B1040 N4518QLloyd Patrick · Durham, NCBuilt 1978 · S/N AA5B1044 N4518REdmondson William A · Rosamond, CAFirst renewal noticeBuilt 1965 · S/N 28-21220 N45199Decou Miller C · Chester Springs, PABuilt 1979 · S/N AA5B1059 N4519EPalocz Spencer F · Weston, MABuilt 1979 · S/N AA5B1051 N451BTNeosho Investments LLC · Neosho, MOBuilt 1967 · S/N 28-23951 N451CDDull Kevin M · Northlake, TXBuilt 1978 · S/N AA5B0995 N451DDJth Holdings LLC · Flemingsburg, KYBuilt 1990 · S/N 1451 N451PSUpside Down Aero LLC · Aberdeen, IDBuilt 1976 · S/N 193-76 N452Chace Stephen B · Bloomington, ILBuilt 1986 · S/N 632 N45204Markelov Sergey · Naperville, ILBuilt 1979 · S/N AA5B1067 N45208Bunker Wayne M · Cape Carteret, NCBuilt 1979 · S/N AA5B1069 N4520ACoogan Timothy J · Anchorage, AKBuilt 1957 · S/N 22-3827 N4520BOhara William P · Atco, NJBuilt 1979 · S/N AA5B1060 N4520LWilliams James A · Newark, DEBuilt 1979 · S/N AA5B1062 N4520NHurley Peter · Clearwater, FLBuilt 1979 · S/N AA5B1063 N4520RBurge John A · Pensacola, FLS/N 28-21222 N4520TBrummell Colten Andrew · Hannibal, MOBuilt 1971 · S/N 28-7105216 N45210Domogala David J · Southbury, CTBuilt 1979 · S/N AA5B1076 N45211Beloit Aviators LLC · Jefferson, WIBuilt 1979 · S/N AA5B1077 N4521C4 Legged Fliers LLC · Brick, NJBuilt 1979 · S/N AA5B1071 N4521LCarey Daniel · Rockville Centre, NYS/N AA5B1072 N4521NMehraban Seyed Habib · Los Angeles, CABuilt 1979 · S/N AA5B1073 N4521RLenz Gregory K · Everton, MOBuilt 1965 · S/N 28-21223 N4521VPirri Anthony N · East Falmouth, MABuilt 1979 · S/N AA5B1075 N4521XClemmons Philip B · Madison, ALBuilt 1975 · S/N 28-7615023

Back to AD 80-04-03 R2