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.

N25675Todd James Michael · Angleton, TXBuilt 1973 · S/N E-472 N25681Heli-Ventures Inc · Wilmington, DEBuilt 1973 · S/N CE-460 N2568XPeasley Casey · Eagle, IDBuilt 1965 · S/N P206-0068 N25691Marty Daniel A · Birmingham, ALBuilt 1973 · S/N CE-462 N256CAHyannis Air Service Inc · Hyannis, MAS/N 402C0606 N256DBNortheastern Gastroenterology Associates Pa · Summit Hill, PABuilt 1998 · S/N E-3081 N256DWN256dw LLC · Orlando, FLBuilt 2010 · S/N E-3926 N256PTBaron Aviation Inc Trustee · Wilmington, DEBuilt 2013 · S/N TH-2350 N256TETimberline Excuvation Inc · Fairbanks, AKBuilt 1969 · S/N U2061336 N25704Arrison Frank J · Doylestown, PABuilt 1973 · S/N E-475 N25717Vaadi LLC · Babson Park, FLBuilt 1973 · S/N D-9542 N25719Brunner Robert L · Jefferson, ORBuilt 1973 · S/N D-9540 N25720Smile Air LLC · Macomb, MIBuilt 1973 · S/N E-479 N2572SGwin Bryan · La Porte, TXBuilt 1976 · S/N 21061332 N2572XC S Enterprises Llp · Morristown, TNBuilt 1965 · S/N P206-0072 N25734Gardner Aviation LLC · Hot Springs, ARBuilt 1973 · S/N TH-390 N2573QJayviation Inc · Lake City, FLBuilt 1969 · S/N 21059173 N2573XSkd LLC · Spokane, WABuilt 1965 · S/N P206-0073 N2575X360 Solo LLC · San Martin, CABuilt 1965 · S/N P206-0075 N2577QSlingsby J Geoffrey · Rapid City, SDBuilt 1977 · S/N 18503520 N257SPAviatzone LLC · Fort Lauderdale, FLBuilt 1977 · S/N 20700781 N2582KSherman David B · Readfield, MEBuilt 1978 · S/N 18053003 N2582PTriple A Aviation LLC · Plano, TXBuilt 2026 · S/N E-4166 N2583SMackowiak Michael · Haines, AKBuilt 1973 · S/N 18502250 N2583XN2583x LLC · Oklahoma City, OKBuilt 1965 · S/N P206-0083 N258BBGhanimian Zaven · Encino, CABuilt 1977 · S/N TH-892 N258DTwin Engine Express LLC · Lewes, DEBuilt 1995 · S/N TH-1740 N258MTK5 Aviation LLC · Lewes, DES/N TH-244 N258NCFidelis Flight Group Inc · Elm Springs, ARBuilt 1978 · S/N TH899 N258PBHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0336 N258RPInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N TH-1737 N258SAEmv Properties LLC · Ponce, PRBuilt 2008 · S/N TH-2224 N258STPanchjanyam LLC · Jackson, MSBuilt 2002 · S/N 0307 N258TCDunn Mark A · Lufkin, TXBuilt 1966 · S/N D-8351 N258TNKrause Jason · Glendale, AZBuilt 1988 · S/N TH-1539 N2591TFerguson John W · Edwardsburg, MIBuilt 1975 · S/N U20602594 N2592XLorraines Blue Sky Aviation LLC · Norman, OKBuilt 1965 · S/N P206-0092 N2596XCarter Jason J · Athena, ORBuilt 1965 · S/N P206-0096 N2597XCavaness Gary Frank Jr · Anchorage, AKBuilt 1965 · S/N P206-0097 N2598XGilliland James H · Curwensville, PABuilt 1965 · S/N P2060098 N259CN259c LLC · Woodward, OKBuilt 2001 · S/N EA-684 N259CDGo Air Brokerage LLC · Wake Forest, NCBuilt 2003 · S/N 0449 N259JHall James A · Bozeman, MTBuilt 1973 · S/N D-9430 N259JPKennedy Wallace III · Beaufort, NCBuilt 1976 · S/N NAV42559 N259MRidgerunner 51 LLC · Springdale, ARBuilt 1966 · S/N 297 N259MMDavidson Bryan H · Sarasota, FLBuilt 1986 · S/N E-2311 N259PBOregon Holdings LLC · Bend, ORBuilt 2001 · S/N 0111 N259TTaylor Ted H · Corsicana, TXBuilt 1967 · S/N D-8664 N25BRJames Roger · Daphne, ALBuilt 1974 · S/N 74-30670 N25BTFernandez Sergio R · Port Saint Lucie, FLBuilt 1981 · S/N D-10373

Back to AD 86-13-04 R3