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.

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 N80871Monnin Aviation LLC · Amherst, NYBuilt 1976 · S/N 17266783 N80872Yakima 872 Flying Club · Yakima, WABuilt 1976 · S/N 17266784 N80874Jls Aviation LLC · Fredericksburg, VABuilt 1976 · S/N 17266786 N8087PWildman Kevin · Brentwood, CABuilt 1962 · S/N 24-3335

Back to AD 79-10-03 R2