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.

N807APTexas South Wind Aviation LLC · Kenedy, TXBuilt 1975 · S/N 28-7615086 N807DAMays Gloriaj · College Station, TXBuilt 1977 · S/N 28-7816227 N807EHLindsey Daniel Rey · Clovis, NMS/N 1242 N807EJBaldmans Aircraft Services LLC · Wilmington, DES/N 18-3519 N807HDTubbs Jerry M · Manns Harbor, NCBuilt 1976 · S/N 17266730 N80800West Bend Air Inc · West Bend, WIBuilt 1976 · S/N 17266752 N80803Bradley Charles S · East Bethel, MNS/N 17266754 N80807Wings Over Texas Holdings LLC · Denton, TXS/N 17266755 N8080AChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1979 · S/N 28-8016051 N8080YEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1356 N80810White Hawk Aviation Inc · Brandy Station, VABuilt 1976 · S/N 17266757 N80816Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1976 · S/N 17266760 N8081CBartlett Branden S · Eagle River, AKBuilt 1953 · S/N 18-3485 N8081DZwiacher John W · Green Lake, WIBuilt 1957 · S/N 18-6072 N8081GGonzalez Biorky · Atoka, TNBuilt 1979 · S/N 28-8016053 N8081HThornton J T · Dora, MOBuilt 2009 · S/N 3588 N8081PCraner Andrew · Richfield, IDBuilt 1979 · S/N 28-8016056 N80820Palmer Thomas T · Kapowsin, WABuilt 1946 · S/N 223 N80824Streamline Aviation LLC · Battlefield, MOS/N 227 N80829Johnson Kyle A · Cheshire, CTBuilt 1946 · S/N 232 N8082EAviation Access LLC · Van Nuys, CABuilt 1978 · S/N 17272135 N8082HWalters Glenn L · Triadelphia, WVBuilt 1979 · S/N 28-8016059 N8082KWood Roger E · Waxhaw, NCBuilt 1979 · S/N 28-8016060 N8082WWallace Louis Wayne · Sherman, TXBuilt 1965 · S/N 28-2172 N80830Mahnattan Flying Tigers Inc · Bozeman, MTBuilt 1976 · S/N 17266764 N80837Lucky Richard E · Skipperville, ALBuilt 1976 · S/N 17266767 N8083DRegistered aircraftBuilt 1957 · S/N 18-6074 N8083WNedelea Traian · Katy, TXBuilt 1965 · S/N 28-2173 N80841Sparta 140 Club Inc · Grand Rapids, MIBuilt 1976 · S/N 17266769 N80842Augusta Aviation Inc · Augusta, GABuilt 1976 · S/N 17266770 N80847Evergreen Flying Club Inc · Medina, WABuilt 1976 · S/N 17266771 N8084NBlack Tie Limousine LLC · Springville, ALBuilt 1981 · S/N 28-8290090 N8084PSmith Wayne R · Pittsford, NYBuilt 1962 · S/N 24-3332 N8084WFieldgrove Matt L · Somerton, AZBuilt 1965 · S/N 28-2174 N80853Candace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 28-8090082 N80855Bowe Joseph E DBA · Chippewa Falls, WIBuilt 1976 · S/N 17266774 N8085ALane Community College · Eugene, ORBuilt 1979 · S/N 28-8016065 N8085EMcdonald Douglas A · Falls Church, VAS/N 17272137 N8085WFireside Aviators Assn Corp · San Jose, CAFirst renewal noticeBuilt 1965 · S/N 28-2175 N8085XGorkes Richard E Jr · Lilburn, GABuilt 1979 · S/N 28-8016068 N80864Kessler Garry A · Lansing, WVBuilt 1976 · S/N 17266778 N80865Green Rick A · Hudson, IABuilt 1976 · S/N 17266779 N80866Preston Richard K Trustee · Albuquerque, NMBuilt 1976 · S/N 17266780 N80868Paradis Paul A · Bar Harbor, MEBuilt 1976 · S/N 17266781 N8086DHinderberger Bryan J · Juneau, AKBuilt 1957 · S/N 18-6079 N8086ECoker Chadwick Daryl · Goldsboro, NCS/N 28-8090083 N8086GMason Aviation Club LLC · Mason, MIBuilt 1979 · S/N 28-8090084 N8086HCloud Catcher Aviation LLC · Great Falls, MTBuilt 1979 · S/N 28-8090085 N8086KClubs 2 LLC · Calabasas, CABuilt 1979 · S/N 28-8090086 N80870Robben William J · Pampa, TXBuilt 1976 · S/N 17266782

Back to AD 80-04-03 R2