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.

N83580Lazy Ye Cattle Co · Dodson, MTBuilt 1977 · S/N 18-7709082 N83582Johnson Gavin Howard · Anchorage, AKS/N 18-7709092 N8358LOc Flight Lessons LLC · Costa Mesa, CABuilt 1968 · S/N 17256558 N8358RHight Mayon C · Snohomish, WABuilt 1966 · S/N 28-22234 N8358WChaney Eddie L · Douglas, GABuilt 1965 · S/N 28-2550 N8358ZMinella Frank A · Old Forge, PABuilt 1981 · S/N 28-8190192 N83594Sjogren Risto L · Felton, CABuilt 1977 · S/N 18-7709095 N83596Carlson Farms Inc · Plentywood, MTBuilt 1977 · S/N 18-7709096 N83598Liley Diana H · Anchorage, AKBuilt 1976 · S/N 18-7709044 N8359WMarble Jere D · Dayton, NVBuilt 1965 · S/N 28-2551 N835SHBuell Travis W · Harper, TXS/N 3801 N835SWBrakey Richard F · Amarillo, TXBuilt 1959 · S/N 18-6829 N83604Crowe Kirby H · Haskell, OKBuilt 1977 · S/N 18-7709097 N8360YOtto Aviation LLC · Gilbertsville, PABuilt 1981 · S/N 28-8190195 N8361LMolid Robert J · Dubuque, IABuilt 1968 · S/N 17256561 N8361WBursch Clint Lee · Bird City, KSBuilt 1965 · S/N 28-2556 N83620Philippi Joseph E · Judith Gap, MTS/N 18-7709086 N83622Trans Crafts LLC · Big Lake, AKBuilt 1977 · S/N 18-7709104 N83629Du Clos Paul R III · Anchorage, AKBuilt 1977 · S/N 18-7709106 N8362PBooth Jason D · Timber Lake, SDBuilt 1965 · S/N 18-8182 N8362RCore Flight Academy LLC · Asheboro, NCBuilt 1966 · S/N 28-22344 N8362WSexton Rick C · Payson, AZBuilt 1965 · S/N 28-2557 N83636Registration Pending · Mansfield, SDRegistration pendingBuilt 1977 · S/N 18-7709108 N8363EEllefson Aircraft LLC · Tyler, MNS/N 28-8116187 N8363HFox John · Asheboro, NCBuilt 1981 · S/N 28-8116188 N8363PLove Richard S · Indianapolis, INBuilt 1981 · S/N 28-8116191 N8363RHancock Allen L · Twentynine Palms, CABuilt 1966 · S/N 28-22239 N8363WRegistered aircraftBuilt 1965 · S/N 28-2558 N8363ZGobel Mario · Belleville, WIFirst renewal noticeBuilt 1981 · S/N 28-8190202 N83642Mehling Molly S · Fairview, MTBuilt 1977 · S/N 18-7709110 N8364CTurner Royce E · Bridgeport, WABuilt 1975 · S/N 28-7615094 N8364EThreet David A · Sand Springs, OKBuilt 1960 · S/N 1542 N8364QBlinn Philipp Randy · Priest River, IDBuilt 1982 · S/N 0311 N8364RSwank Freeman J · Fort Myers, FLBuilt 1966 · S/N 28-22240 N8365LHarbour Aviation LLC · Weatherford, TXBuilt 1968 · S/N 17256565 N8365RRegistration Pending · Lake City, FLRegistration pendingBuilt 1966 · S/N 28-22241 N8365VJarvis Stormy A · Anchorage, AKBuilt 1966 · S/N 66 N8365WAbramczyk Randall L · Delta, OHBuilt 1965 · S/N 28-2562 N8365ZScorse Jeffrey A · Lunenburg, MABuilt 1981 · S/N 28-8116196 N83665Gosman John L · Milton, KYBuilt 1977 · S/N 18-7709112 N83666Baugh Aviation Inc · Lebanon, TNBuilt 1982 · S/N 0314 N83669Davis Jonathan R · Anchorage, AKBuilt 1979 · S/N 18-7909049 N8366LCurwin Randy S · Villa Rica, GABuilt 1968 · S/N 17256566 N8366NLakes Region Flying Club Inc · Gilford, NHBuilt 1981 · S/N 28-8190205 N8366RMoyer Jay R · Corry, PABuilt 1966 · S/N 28-22242 N83672Quinn Dennis D · Fairbanks, AKS/N 18-7709115 N83675Mcmahan Harley B · Gakona, AKBuilt 1977 · S/N 18-7709116 N83679Pro-Air West LLC · San Diego, CABuilt 1977 · S/N 18-7709117 N8367LRay Allens Electronics Inc · Butler, GABuilt 1968 · S/N 17256567 N8367PThomas Joe C · Osceola, ARBuilt 1964 · S/N 24-3625

Back to AD 79-10-03 R2