Skip to content

Registered aircraft · 40,471

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.

N8094NEggan Mark A · Lee Center, NYBuilt 1968 · S/N 28-25337 N8094QSpitzer Helicopter LLC · Woodland Hills, CABuilt 1993 · S/N 2385 N8094WMatney Tara · Abingdon, VABuilt 1965 · S/N 28-2188 N80952Registered aircraftBuilt 1976 · S/N 17266817 N80959Mets Flying Club Inc · Fairmount, INBuilt 1976 · S/N 17266819 N8095WSkierka Michael A · Browning, MTBuilt 1965 · S/N 28-2189 N80960Perry Robert Lawrence Trustee · Salinas, CABuilt 1946 · S/N 1153 N80961A S Air LLC · Lantana, FLBuilt 1976 · S/N 17266820 N80964Three Wing Flight School LLC · Stratford, CTBuilt 1981 · S/N 28-8216108 N80968Wisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 28-8016087 N8096LRhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1999 · S/N 1999 N8096QHoover Charles J · Logansport, INBuilt 1981 · S/N 28-8216107 N8096WRoberts Heather V · Birmingham, ALBuilt 1965 · S/N 28-2190 N80972Porter Timothy D · Saint Cloud, MNBuilt 2000 · S/N 60081 N80975N80975 LLC · Wilmington, DEBuilt 1976 · S/N 17266821 N8097HMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-8016092 N8097JAjdari Rodmehr · Millville, NJBuilt 1979 · S/N 28-8016093 N8097PEmery Jonathan D · Payson, AZBuilt 1979 · S/N 28-8090106 N8097QHissey Mark E · Fannettsburg, PABuilt 1980 · S/N 28-8090107 N8097SBrookwood Plastering Inc · San Diego, CABuilt 1979 · S/N 28-8090108 N80982Reiselt Paul T F · Corinth, MSBuilt 1976 · S/N 17266825 N80985Mullins James C · Franklin, TNBuilt 1976 · S/N 17266826 N8098BIowa Aircraft Inc · Burlington, IABuilt 1979 · S/N 28-8090110 N8098ERegistered aircraftN-number assigned, not yet registeredS/N 17272140 N8098MRock Solid Aviation LLC · Lake Charles, LABuilt 1979 · S/N 28-8090111 N8098NBlessing Gary · Cape Coral, FLBuilt 1968 · S/N 28-25342 N80991Flowers Robert Clyde III · Manchaca, TXBuilt 1976 · S/N 17266830 N80996Halley Dan R · Avery, TXBuilt 1976 · S/N 17266832 N8099WClarion County Flight Club LLC · Shippenville, PABuilt 1965 · S/N 28-2194 N809APPhillips William Wade · Lake Charles, LAS/N 21823 N809BTLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1976 · S/N 17267437 N809STDiaz Natanael Luna · Toa Baja, PRS/N 17268873 N80ANStephany Peter T · Umatilla, FLBuilt 1980 · S/N 18-8109003 N80BJRegistration Pending · Jasper, GARegistration pendingBuilt 1977 · S/N 18-7709191 N80CHMoyer Hunter · Rapid City, SDS/N AA5B-0496 N80DKAutoair Research Inc · Wilmington, DEBuilt 1994 · S/N 1685 N80EZHolliday Mathew J · Limerick, PABuilt 1988 · S/N 941 N80FPCarastro Enterprises LLC · Montgomery, ALBuilt 1978 · S/N 17271343 N80FTWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 2000 · S/N 2842078 N80GGOgg Richard A · San Lorenzo, CABuilt 1996 · S/N 7 N80GLNear William J · Weirsdale, FLBuilt 1980 · S/N 0GL-0125 N80HYBrooks Eugene D IV · Cross Plains, TNBuilt 2005 · S/N 2288 N80LCHubbert Stephen A · Newcastle, OKBuilt 1993 · S/N 38 N80LSClow Streeter M · Mansfield, OHBuilt 1976 · S/N 18-7609096 N80PDGatpandan Grace Michele V · Martinez, CABuilt 1967 · S/N 28-4044 N80PYZimbric Benjamin · Brooklyn, NYBuilt 2013 · S/N 24507 N80SBBrewer Renner L Jr · Sonora, CABuilt 1980 · S/N 0062 N80TRRender Thomas R · Eden Prairie, MNFirst renewal noticeBuilt 1956 · S/N 18-4844 N80XLWolf Lawrence A · Wyoming, OHBuilt 2008 · S/N 82688 N80YRInternational Engineering & Sourcing · Oklahoma City, OKS/N 60052

Back to AD 80-04-03 R2