Skip to content

Registered aircraft · 40,472

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.

N150ATRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1994 · S/N 04940069 N150AYLegacy Aviation Foundation Inc · Staten Island, NYBuilt 1995 · S/N 04940073 N150BKTribec Inc · Medina, OHBuilt 1969 · S/N 15070857 N150CJMorrell John I · Seymour, TNBuilt 1994 · S/N 04940064 N150CWCleveland William L · Lander, WYS/N 18-4329 N150DHHollenbaugh Roger Dean · Jamestown, COBuilt 1987 · S/N 240 N150EPGedney William · Lake George, NYBuilt 1959 · S/N 18-7087 N150FSCustom Air International LLC · Homestead, FLBuilt 1975 · S/N 17265554 N150HCJones Luis · Las Vegas, NVS/N A1500725 N150HPGrimes Brian T · Kingman, AZS/N 001 N150KSSommers Stuart S · Newberg, ORBuilt 1951 · S/N 20-678 N150LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842193 N150MFRevolution Robotics Inc · Corvallis, ORBuilt 2001 · S/N 0015 N150MMAdams Jon S · Whitmore Lake, MIBuilt 1984 · S/N M-1-1115 N150NDClear Skies Avionics Inc · Clearwater, FLS/N 1186 N150NHPalmer Ronald Everett Trustee · Hopkinton, NHBuilt 1983 · S/N 18-8309012 N150PPBurghduff Aviation LLC · Ludlow, SDS/N 25-23 N150RVHolleman Charles F · West Lafayette, INBuilt 1987 · S/N 959 N150SDLauff Samuel Jr · Ocala, FLBuilt 1998 · S/N 105 N150STMiles Donald C · Columbia, MOBuilt 1977 · S/N 2996 N150TBStevann Farms Ltd · De Witt, IABuilt 1959 · S/N 18-4303 N15100Brothers Aviation Va LLC · Manassas, VABuilt 1972 · S/N 28-7225588 N15101Blackwater Air LLC · Pace, FLBuilt 1972 · S/N 28-7305020 N15104Mil2atp Inc · Pikeville, NCBuilt 1972 · S/N 28-7225590 N15105Sass Phillip A · Leavenworth, KSBuilt 1972 · S/N 28-7225591 N15106Chew Terrence G · Allyn, WABuilt 1972 · S/N 28-7305021 N15107Skahen Sean M · Saint Joseph, MNS/N 28-7305022 N15115Price Michael D · Shell Knob, MOBuilt 1972 · S/N 28-7305023 N15121Airborne Aviation LLC · Anchorage, AKFirst renewal noticeBuilt 1972 · S/N 28-7225589 N15122Dixson Joel T · Corpus Christi, TXBuilt 1972 · S/N 28-7225595 N15123Blackwood Aviation Services Inc · Orlando, FLBuilt 1972 · S/N 28-7305025 N1512JHorning Timothy J · Saegertown, PABuilt 1967 · S/N 28-23906 N15132Lewis University · Romeoville, ILBuilt 1972 · S/N 28-7225597 N1513XTurner Gary H · Big Stone Gap, VABuilt 1975 · S/N 28-7505237 N15140Anthony J Cariotte Jr · Holbrook, NYBuilt 1972 · S/N 28-7225598 N15141Murphy Jeffrey S · Mechanicsburg, PABuilt 1972 · S/N 28-7305027 N15142Dj Aviation LLC · Rio Vista, TXS/N 28-7305028 N15148Brown Jerry Keith · Calera, ALBuilt 1972 · S/N 28-7225599 N1514AMatthews Byron Kim · Hooper, UTS/N 20-703 N1514JBooher Greg F · Livingston, TNBuilt 1967 · S/N 28-23908 N1514TTucker David J · Welch, OKBuilt 1972 · S/N 28-7225539 N1515JMendenhall William R II · Beebe, ARS/N 28-23909 N1515ROwen Ray M · Columbia Station, OHBuilt 1974 · S/N AA5B-0015 N15160Western Aire Flying Club Ltd · Sparta, WIBuilt 1972 · S/N 28-7305030 N1516JH&H Holding LLC · Tucson, AZBuilt 1967 · S/N 28-23911 N1516PRichardson Sean W · Delta Junction, AKS/N 22-2381 N1516RMckenzie Pools Inc DBA · Springfield, ORFirst renewal noticeBuilt 1974 · S/N AA5B-0016 N1516VAircraft Management Services Inc · Milton, FLBuilt 1974 · S/N 17263638 N15176St Germain Joseph Ronald · Glenview, ILBuilt 1972 · S/N 28-7305032 N15179Henson Ricky T · Covington, TNBuilt 1972 · S/N 28-7225601

Back to AD 80-04-03 R2