Skip to content

Registered aircraft · 40,394

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

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 N8100NSpeicher Peter · Grand Forks, NDBuilt 1968 · S/N 28-25288 N8100THwang Glenn · Glen Carbon, ILBuilt 2004 · S/N 25447 N8100WWaggoner Alan L · Blanchard, OKBuilt 1965 · S/N 28-2195 N8100YHagaman Boynton C · Berryville, VABuilt 1967 · S/N 18-8582

Back to AD 79-10-03 R2