Skip to content

Registered aircraft · 40,395

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.

N32SPCochran Gene P · Silverdale, WABuilt 1976 · S/N 28-7690199 N32WTEdwards Anthony C · Weaverville, CABuilt 1990 · S/N 1495 N32YAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1980 · S/N 17273862 N32YBHjelle Mark L · Barrett, MNBuilt 2000 · S/N 80613 N33000Sindlinger Lyle · Puyallup, WABuilt 1971 · S/N HH-1 N33001Peak Builders Inc · San Diego, CAS/N 28-7525134 N3300PDiscover Resources LLC · Norman, OKBuilt 2003 · S/N 90275 N3300ZKoliastasis Pete · Reno, NVBuilt 1959 · S/N 22-7231 N33017Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1975 · S/N 28-7515289 N33018Lovingier Michael J · Glendale, AZBuilt 1975 · S/N 28-7515290 N3301PDramstad Flying Service LLC · Helena, MTBuilt 1958 · S/N 23-1251 N3301ZWood Paul S · Lawton, OKBuilt 1959 · S/N 22-7232 N3302DGeorge Clifford E · Starkville, MSBuilt 1997 · S/N 3302 N3302ZMeginnes Mark A · Tucson, AZS/N 22-7234 N33030Fanopoulos Joshua J · Boise, IDS/N 28-7525139 N3303ZZanis Paul M · Wolfeboro, NHBuilt 1959 · S/N 22-7233 N33046American Eagles Flying Club · New Hudson, MIBuilt 1975 · S/N 28-7505114 N3304BDoty Danial J · Talkeetna, AKBuilt 1956 · S/N 22-2119 N3304PBucket List Aviation LLC · San Jose, CABuilt 1958 · S/N 23-1254 N3305PAir Royal · Middletown, DEBuilt 1958 · S/N 23-1255 N33061Piper 33061 LLC · Rustburg, VABuilt 1975 · S/N 28-7505116 N33064Facklair LLC · Granville, OHS/N 28-7505117 N3306EBlackwell Calvin C · Fort Worth, TXBuilt 1978 · S/N 17271498 N33077Klug Ryan Gregory · Lincoln, NEBuilt 1975 · S/N 28-7525149 N33079Devaney Aviation Inc · Palm City, FLS/N 28-7525150 N3307PAlbano James R · Oakham, MAFirst renewal noticeBuilt 1958 · S/N 23-1257 N33081Tofan Ray · Chula Vista, CAS/N 28-7505119 N33083Barnhill Chris · Carbondale, ILBuilt 1975 · S/N 28-7505120 N3308ZWeber Daniel Troy · Port Charlotte, FLS/N 22-7239 N33092Shepherd Edward H · Grass Valley, CABuilt 1975 · S/N 28-7525153 N3309JMomentum Foundation · Tullahoma, TNS/N 15066009 N3309ZRubbert Randy C · Reynolds, NDBuilt 1959 · S/N 22-7241 N330ARegistered aircraftBuilt 1954 · S/N 22-1939 N330CPCharlie Pop Flyers Inc · Jacksonville, FLBuilt 1969 · S/N 30-1884 N330CTRobinson Paul J · Saint Joseph, MOBuilt 1974 · S/N 17702158 N330DDUtah State University · Logan, UTBuilt 2002 · S/N 3401 N330FTSuwannee Arrow LLC · Clearwater, FLBuilt 1982 · S/N 28-8216209 N330HLSwift David A Trustee · Springfield, MOS/N 24941 N330KRCherry Hill Aviation Inc · Freetown, INBuilt 1956 · S/N 22-4152 N330MFWroblewski Peter Ross · Lompoc, CABuilt 2003 · S/N 0033 N330MMHobbs Phillip E · Saint Augustine, FLBuilt 1983 · S/N 444 N330RLBlue Mountain Flyers · Palmerton, PABuilt 2002 · S/N 2210 N33107Florida Coastal Flying Club LLC · Titusville, FLBuilt 1975 · S/N 28-7525154 N3311KBartholomew Donald B · Gardnerville, NVBuilt 1946 · S/N 1304 N3311TSchulze Tom L · Smithville, MOBuilt 1967 · S/N 17700611 N33121Civil Air Patrol Flying Association Inc · Branford, CTBuilt 1975 · S/N 28-7505124 N33128Flora Airport Authority · Flora, ILBuilt 1975 · S/N 28-7505125 N33138Ables John M · Tehachapi, CABuilt 1975 · S/N 28-7525161 N33139Hallert Benjamin F · Springfield, ORBuilt 1975 · S/N 28-7515320 N33147Johann Austin J · Richland Center, WIS/N 28-7525163

Back to AD 79-10-03 R2