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.

N6588XPc Rental LLC · Ely, MNBuilt 1980 · S/N U20605962 N6589MHaller Eugene Z · East Hampton, NYBuilt 1977 · S/N 21061979 N658DGSchardt Aaron · Hastings, NEBuilt 1981 · S/N TH-1324 N658JSTwo River Airspray LLC · Cavalier, NDBuilt 1977 · S/N TJ100 N658MWitherington Properties Inc · Oak Ridge, TNBuilt 1982 · S/N TJ429 N6591NRickey James R · Hanford, CAFirst renewal noticeBuilt 1978 · S/N 21063114 N6593UWedt LLC · Wilmington, DEBuilt 1983 · S/N TH-1371 N6593WSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N P21000801 N6594CMaiden Assets LLC · Norfolk, VABuilt 1980 · S/N 335-0056 N6597CHai Services Inc · Haltom City, TXBuilt 1978 · S/N 414A0028 N659RJFoerstel Edward · Miami Beach, FLBuilt 1984 · S/N 421C1408 N659TLucy Donald E III · Newbury Park, CABuilt 1972 · S/N D-9357 N65ACCraft Charles Edward · Shepherdstown, WVBuilt 1966 · S/N TE-242 N65AJAitkens Larry · Port Saint Lucie, FLBuilt 1966 · S/N D-8099 N65BEStarwood Air LLC · Missoula, MTBuilt 1994 · S/N E-2837 N65BKAircraft Management Sales And Service Inc · East Longmeadow, MABuilt 2015 · S/N E-4061 N65BWBuzzard Max · Tulsa, OKS/N D-8294 N65DBrowndog LLC · Lksid Marblhd, OHBuilt 1972 · S/N 3400092 N65EAPhilbrick Quinn R · Rangeley, MEBuilt 1966 · S/N 1850997 N65JEVan Wadle Aviation LLC · Blairsville, GABuilt 1978 · S/N E-1231 N65JKAmerican Aircraft & Marine LLC · Indianapolis, INBuilt 1973 · S/N 74-30641 N65JMGjf Enterprises Inc · Port Orange, FLBuilt 1974 · S/N TE-991 N65KBBurke Daniel P · Oyster Bay, NYBuilt 2004 · S/N 0808 N65LKLift Enterprise LLC · Helena, MTBuilt 2005 · S/N 1737 N65LMAero Compression LLC · Macon, GABuilt 1999 · S/N TH-1902 N65LVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1966 · S/N D-8238 N65MJPlane Fun Inc Tr Trustee · Snellville, GABuilt 1985 · S/N TJ-487 N65NOlterman Robin L · John Day, ORBuilt 1971 · S/N U20601729 N65PDVerhalen Flyers LLC · Marshall, TXBuilt 1995 · S/N 29-0052 N65QTvs LLC · Oak Park, ILBuilt 1974 · S/N CE-493 N65RPE-Co Aviation LLC · Wilmington, DEBuilt 1979 · S/N 414A0287 N65SBJarrett Airspray Inc · Jamestown, NDBuilt 1965 · S/N D-7905 N65SH65 Sierra Hotel LLC · Wilmington, DEBuilt 1970 · S/N CJ-28 N65TCCloud 8 LLC · West Hartford, CTBuilt 1987 · S/N E-2385 N65TYMbessette LLC · West Ossipee, NHBuilt 2005 · S/N 1452 N65VBCollins Scott W · Upland, CABuilt 1965 · S/N D-7821 N65VRAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2021 · S/N 27016C N65VTAsclepiad Aviation LLC · San Antonio, TXBuilt 2003 · S/N 3RX111 N65YLippman Thomas N Trustee · Brisbane, CABuilt 1977 · S/N D-10080 N6600CHulen Christopher A · Conroe, TXBuilt 1982 · S/N CE-967 N6600LBonanza Partners LLC · Newton Centre, MABuilt 1977 · S/N E-1074 N6600VLeahy Thomas J · Marblehead, OHBuilt 1970 · S/N 30261 N6601NMcfarland Andrew J · Camarillo, CABuilt 1983 · S/N CE-1015 N6601VJofredo Corp · Zephyrhills, FLBuilt 1970 · S/N 30294 N6602CSnip Robert C · Telluride, COBuilt 1980 · S/N 21063926 N6603VCmbb Enterprises LLC · Plainview, TXBuilt 1970 · S/N 30275 N6604VKidd Clifford L · Monahans, TXS/N 30267 N6605VWaller Earl D · Wyoming, DEBuilt 1970 · S/N 30280 N6605XCifelli Michael A · Bay Shore, NYBuilt 1983 · S/N CE-1016 N6606QAirtrust LLC - 1 - Series 1 Trustee · Sheridan, WYBuilt 1977 · S/N 18802951T

Back to AD 86-13-04 R3