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.

N6828RDaves Aircraft LLC · Eden, NCBuilt 1981 · S/N 340A1227 N6829WGroupe Caraibe LLC · Wilmington, DEBuilt 1984 · S/N EA-407 N682JDWindward Air LLC · Orlando, FLBuilt 1981 · S/N 414A0802 N682JSIflyhigh LLC · Phoenix, AZBuilt 1981 · S/N 340A1237 N6830LN661w Air LLC · Dalton, GABuilt 1980 · S/N 310R2102 N6830RElizalde Carla Zankiz · Estero, FLBuilt 1967 · S/N T210-0230 N68310Redcell Air Inc · Miami, FLBuilt 1979 · S/N 310R1614 N6831MSouth Beach Adventure Sports LLC · Bald Head Island, NCBuilt 1977 · S/N 21061994 N6832RWheeler David G Jr · Chico, CAS/N T210-0232 N6832YPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1980 · S/N 310R2121 N6833LBentley Timothy · Richmond, KYBuilt 1981 · S/N 310R2125 N6833TBartek Ronald T · Lake Charles, LABuilt 1981 · S/N 310R2128 N6834APlum Family Buildings LLC · Marengo, IABuilt 1984 · S/N EA-408 N68379Express Carrier LLC · St Thomas, VIBuilt 1981 · S/N 402C0469 N6838XOcean Flight Corp · Weston, FLBuilt 1978 · S/N 402B1346 N68391Hyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0483 N6839RGolden Wings LLC · Tampa, FLBuilt 2002 · S/N 0405 N6839YRichland Aviation Inc · Sidney, MTBuilt 1981 · S/N 402C0481 N683DDPriddy Ventures LLC · Greensboro, NCBuilt 2007 · S/N TH-2175 N683EARed Baron LLC · Dickinson, NDBuilt 2008 · S/N E3863 N683JWLotela Partners LLC · Avon Park, FLBuilt 1980 · S/N 21063982 N683SDMurray Steven L · Webster, NYBuilt 1980 · S/N EA-148 N683TM007 Arkansas Aviation LLC · Jonesboro, ARBuilt 1979 · S/N 414A0237 N6840QIdell Enterprises LLC · Wilmington, DEBuilt 1964 · S/N D-7445 N6843RArkansas Air LLC · Jackson, WYBuilt 1966 · S/N T210-0243 N6846CDillon T34 6846c LLC · Scottsdale, AZS/N CCF34-58 N6847RAlpine Aviation LLC · Oklahoma City, OKFirst renewal noticeBuilt 1967 · S/N T210-0247 N684BCRegistered aircraftBuilt 2005 · S/N 1295 N684SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1969 · S/N 20700147 N684WVery Vero Aviation LLC · Vero Beach, FLBuilt 2008 · S/N E-3864 N684WTMaxwell Duane T Trustee · Visalia, CABuilt 1979 · S/N E1533 N6850BJennings Donald J · Gypsum, COS/N 21062845 N6851R6851r LLC · Greeley, COS/N T210-0251 N6852RJensen Sid R · Idaho Falls, IDBuilt 1967 · S/N T210-0252 N6855QPlehn Thomas R Trustee · Las Vegas, NVBuilt 1964 · S/N D-7464 N6855RD & N Holdings Inc · Boca Raton, FLBuilt 1967 · S/N T210-0255 N6857RRegistered aircraftBuilt 1967 · S/N T210-0257 N6859RRomeo Airmotive LLC · Stockton, CABuilt 1967 · S/N T210-0259 N685CPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 310R-1375 N685DMMetcalf Steven · West Union, IABuilt 2002 · S/N 0322 N685GTEatmb Air Inc Trustee · Wilmington, DEBuilt 1979 · S/N 21063361 N685LDPhoenixarrowcommander LLC · Key West, FLBuilt 1973 · S/N 12020 N685SSecond Wind Aviation Corp · Friday Harbor, WABuilt 1970 · S/N 20700184 N685TBYankee Flyers Inc · Mount Vernon, IABuilt 1973 · S/N E-469 N6860QEschenbach Ralph · San Jose, CABuilt 1964 · S/N D-7475 N6861RJohnson Bradley Michael · Belgrade, MTBuilt 1967 · S/N T210-0261 N6864RRankin Bryan · Cloverdale, CABuilt 1967 · S/N T210-0264 N6866ROrnes W Harold · Aiken, SCBuilt 1967 · S/N T210-0266 N6867CHelms Foodservice Inc · Lake City, FLBuilt 1980 · S/N 335-0061 N6868RChrisman Charles Griggs · Denver, COS/N T210-0268

Back to AD 86-13-04 R3