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.

N8062WGolden Wings Aviation LLC · Kamas, UTS/N 28-2142 N80635Clements Calvin · Palmyra, PABuilt 1976 · S/N 17266683 N80636Walls George H · Matthews, NCBuilt 1976 · S/N 17266684 N8063CHigh Planes Aviation LLC · Goodland, KSBuilt 1975 · S/N 28-7690100 N8063NDean Ralph G · Alfred, MEBuilt 1968 · S/N 28-25313 N8063VMiller Wade L · Roberts, MTS/N 18-8009057 N8063ZUS Helicopter Services Inc · Rochester Hills, MIBuilt 1989 · S/N 1207 N80641Missionary Flight Training Inc · Fort Pierce, FLBuilt 1976 · S/N 17266686 N80643Santa Barbaara Flying Club · Goleta, CABuilt 1976 · S/N 17266687 N8064RN8064r LLC · Kalispell, MTBuilt 1970 · S/N MB-492 N8064WSled Aviation LLC · Prosper, TXBuilt 1965 · S/N 28-2146 N80657Shelburne Airport Inc · Shelburne, VTBuilt 1976 · S/N 17266693 N8065HJehnes Jens W · Cocoa, FLBuilt 1980 · S/N 434 N8065NSotelo Kaleb N · Visalia, CABuilt 1968 · S/N 28-25315 N8065WGard Roger L · Danville, IAS/N 28-2147 N80669Buchert Barbara K · Shrewsbury, MABuilt 1976 · S/N 17266696 N8066NSouthern Air Services LLC · Myakka City, FLBuilt 1968 · S/N 28-25316 N8066UBayphoto Helicopter LLC · Rehoboth Beach, DEBuilt 1990 · S/N 1273 N8066WWilson Jamal Abdul · White Plains, MDBuilt 1965 · S/N 28-2151 N80670Jb Aviation Management Inc · Wonder Lake, ILBuilt 1976 · S/N 17266697 N80673Mitchell Aviation LLC · Mitchell, SDBuilt 1976 · S/N 17266698 N80678Aero Maintenance Inc · Vancouver, WABuilt 1976 · S/N 17266699 N8067DBurgess Bruce A · Saint Johns, MIS/N 22-5590 N8067NCsp Avionics LLC · Knoxville, TNBuilt 1968 · S/N 28-25317 N80684Domino Adam P · Saint Petersburg, FLBuilt 1946 · S/N 1089 N8068CThunderbird Aircraft Company · Bloomington, MNBuilt 1981 · S/N 28-8216099 N8068JGo Vertical Aviation LLC · Russellville, ALBuilt 1981 · S/N 28-8290084 N8068WRkd Flier Inc · Nemaha, IABuilt 1965 · S/N 28-2154 N8068ZBasco John J · Pottstown, PABuilt 1981 · S/N 28-8290086 N80692Registered aircraftBuilt 1976 · S/N 17266703 N80697Moe-Air LLC · Cincinnati, OHBuilt 1976 · S/N 17266705 N8069DCasey Michael B · Hemingford, NEBuilt 1957 · S/N 18-6051 N8069NRajski Douglas S · Freeburg, ILBuilt 1968 · S/N 28-25319 N8069WAdventures In The Sky Aviation LLC · Fresno, CABuilt 1965 · S/N 28-2155 N806CWWilling John W · Grove City, OHBuilt 1965 · S/N 28-2152 N806DAPeak Leasing LLC · Anchorage, AKBuilt 1977 · S/N 17270154 N806EHFisher Air LLC · Cardington, OHBuilt 1990 · S/N 1452 N806FTJohnson Daniel S · Louisville, KYBuilt 1985 · S/N K80-001 N806HAFlywell Aviation LLC · Bowling Green, KYBuilt 1976 · S/N 17266669 N806TDWall Joseph J · Chamberlain, SDBuilt 1957 · S/N 22-4840 N80700Changes In Latitude LLC · Kingwood, TXBuilt 1976 · S/N 17266706 N8070UMartin Jack W Jr · Dublin, GABuilt 2006 · S/N 90179 N8070WMordini Robert D · Grand Marais, MNFirst renewal noticeS/N 28-2156 N8071NFigone David Anthony · Williams, AZBuilt 1968 · S/N 28-25321 N8071SNolan Cynthia M · Rimrock, AZBuilt 1981 · S/N 28-8216102 N8071WFernandez Gregory · San Antonio, TXBuilt 1965 · S/N 28-2158 N8071XFlorida Aviation Career Training Inc · Saint Augustine, FLS/N 28-8216103 N8071YFrost Aviation Services Inc · Las Cruces, NMBuilt 1981 · S/N 28-8216104 N8071ZScanlon Daniel T Jr · East Greenwich, RIBuilt 1981 · S/N 28-8290087 N80725High Flight Academy LLC · Allison Park, PAS/N 17266716

Back to AD 80-04-03 R2