Skip to content

Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N59049Scarry David Charles · San Luis Obispo, CABuilt 1973 · S/N 21060049 N5904FRegistered aircraftBuilt 1967 · S/N 21058904 N5905SLutes Ralph E · Shipshewana, INBuilt 1966 · S/N D-8130 N59060Agriflite Services Inc · Wakarusa, INBuilt 1973 · S/N 21060059 N59073Hartenstine Michael Carl · Lancaster, CABuilt 1973 · S/N 21060069 N5907FIsland City Seaplanes Inc · Cordova, AKBuilt 1967 · S/N 21058907 N5908FCharger Aviation LLC · Chariton, IABuilt 1967 · S/N 21058908 N5909FHendrix Benton · Eckley, COBuilt 1967 · S/N 21058909 N590CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 0957 N590FMTrrek Enterprises LLC · Sunriver, ORBuilt 1966 · S/N 320D0095 N590JGMark V Aviation LLC · Missoula, MTBuilt 2002 · S/N 40044 N590PMMcewen Drew M · Wichita, KSBuilt 1969 · S/N D-8909 N59105Allen Willis M Jr · El Cajon, CABuilt 1973 · S/N 21060093 N5910MCross Country Well Service LLC · Farmington, NMS/N 340-0067 N5910SCrow River Aviation LLC · Watertown, MNBuilt 1966 · S/N D-8122 N5912STop Hand Field Service LLC · Stillwater, OKBuilt 1968 · S/N D-8830 N59141Peters Mark E · Newport News, VABuilt 1973 · S/N 21060118 N59146Universal Charter Service Inc · Auburn, CABuilt 1974 · S/N U20602624 N5915FJeffries Phillip L · Belington, WVBuilt 1967 · S/N 21058915 N59164Marine Electrical & Refrigeration Of Kodiak LLC · Kodiak, AKBuilt 1974 · S/N U20602626 N5916FTlc Flying Inc · Colfax, WABuilt 1967 · S/N 21058916 N5916MQuest Aviation Inc · Lake City, FLBuilt 1973 · S/N 402B0365 N5916SCross Gerald S · Fresno, CABuilt 1966 · S/N D-8124 N59173Vogelgesang Randy · Gardnerville, NVBuilt 1973 · S/N 21060141 N591CDac-2020 Inc · Skaneateles, NYBuilt 2002 · S/N 0439 N591WTLamb Douglas · Douglasville, GABuilt 2010 · S/N E-3939 N5920SLukan Duane G Trustee · Liberty Lake, WAS/N D-8131 N59210Safe Pilots Group LLC · Nyack, NYBuilt 1973 · S/N 21060161 N59237Boland Matthew S · Anchorage, AKBuilt 1974 · S/N U20602637 N59240Banegas Jose Carlos Zankiz · Flint, TXBuilt 1974 · S/N 21060174 N5924SN5924s LLC · Fayetteville, GABuilt 1966 · S/N CE-42 N59258Energy Roofing Technology Se LLC · Lake City, FLS/N 21060180 N59286Staley Ronald L · Lebanon, ORBuilt 1974 · S/N U20602643 N5928FKerr Daniel · Bakersfield, CABuilt 1967 · S/N 21058928 N59292Cloud Busters LLC · Goodrich, MIBuilt 1974 · S/N 21060196 N59294Cornucopia Investment Group LLC · South Jordan, UTBuilt 1974 · S/N U20602645 N59299Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 21060199 N5929SPalmer Wade D · Adair, OKBuilt 1966 · S/N D-8137 N592GCFogelson Robert A · Tillamook, ORBuilt 1972 · S/N 340-0152 N592KBCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601770 N592SMStewart Robert D · Strasburg, COBuilt 1973 · S/N D-9563 N5930FCable Strong Aircraft Holdings LLC · Tyler, TXS/N 21058930 N5931MSteven F Danz LLC · Encino, CABuilt 1972 · S/N 340-0071 N5931SRenton Flyers Inc · Woodinville, WABuilt 1966 · S/N D-8134 N5932SRomain Dallas B · Fort Benton, MTS/N TE-125 N59348Jeff Loenig Farms LLC · Yuma, COBuilt 1967 · S/N D-8527 N5936GMi Transport LLC · Dallas, TXBuilt 2009 · S/N E-3896 N5937FDodson International Parts Inc · Rantoul, KSBuilt 1967 · S/N 21058937 N5937SGaddis Matthew S · Marsing, IDBuilt 1966 · S/N D-8144 N5938MKarlen John R · Boring, ORS/N 340-0074

Back to AD 86-13-04 R3