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.

N6745RHurt Todd A · Springfield, ORBuilt 1966 · S/N T210-0145 N6745TSeaman David S · Sunset Beach, NCFirst renewal noticeBuilt 1980 · S/N CE-902 N6745YSeamech International Inc · Houston, TXBuilt 1984 · S/N EA-401 N6746BMoran Ted B · Spokane, WABuilt 1980 · S/N D-10344 N6746FQuality Motors Inc · Samson, ALBuilt 1983 · S/N CE-1024 N6746RSchwartz Daniel T · Meeker, COBuilt 1966 · S/N T210-0146 N6746TFlying Wolf LLC · Lomita, CABuilt 1980 · S/N E-1674 N6747YZ2b Aviation LLC · San Antonio, TXS/N E-1676 N6747ZMclouth Fred E · Elkhorn, NEBuilt 1980 · S/N D-10346 N6748CSan Andres Farms · Raymondville, TXBuilt 1980 · S/N EA-76 N6748PSpears Derek · Los Angeles, CABuilt 1984 · S/N E-2131 N6748VCannon Oil & Gas Well Services Inc · Rock Springs, WYBuilt 1980 · S/N TK-120 N6749GLesh Air LLC · Denver, COBuilt 1980 · S/N E-1679 N6749LGtf Aviation LLC · Fryeburg, MEBuilt 1980 · S/N E-1678 N6749RPmbarrett Aviation LLC · Tucson, AZBuilt 1966 · S/N T210-0149 N6749VUsg Assets Inc · Clarkesville, GABuilt 1980 · S/N E-1681 N674CCTrn Aviation LLC · Mcallen, TXS/N 414-0453 N674CDEagle Air US Inc · Eau Claire, WIBuilt 2005 · S/N 1738 N674DMBravo Aviators LLC · Argyle, IABuilt 1974 · S/N CE-495 N674PCLegal Wings I LLC · Overland Park, KSBuilt 1978 · S/N 340A0544 N674TTumbling Mirth Mt LLC · Cody, WYBuilt 1969 · S/N D-9007 N6750VSouth Delta Aviation Inc · West Helena, ARS/N TJ-275 N6752XIyer Vijay · Mammoth Lakes, CABuilt 1980 · S/N TJ-276 N6753HJsy Aviation LLC · Port Angeles, WABuilt 1983 · S/N EA-395 N6753RCooper Melvyn R Jr · Albany, GAFirst renewal noticeBuilt 1966 · S/N T210-0153 N6754RJarvis Ronald Louis · Gig Harbor, WABuilt 1966 · S/N T210-0154 N67574International Air Services Inc Trustee · Carson City, NVS/N TE-1194 N6757RRock Air LLC · Round Mountain, NVS/N T210-0157 N67586Carwashos LLC · Colorado Springs, COBuilt 1983 · S/N EA-397 N6758XAc Green LLC · Athens, OHBuilt 1980 · S/N TK-134 N6759GTrademark Services LLC · Vineyard Haven, MABuilt 1980 · S/N E-1682 N6759JConrick Charles J IV · Fort Myers, FLBuilt 1984 · S/N CE-1040 N6759RRegistered aircraftS/N T210-0159 N675BWFreedman Stephen Eric · Falls Church, VABuilt 1978 · S/N D-10134 N675CBWe B Flyers Ltd · Wilmington, DEBuilt 2003 · S/N 0515 N675RVb Flying LLC · Cornelius, NCBuilt 1981 · S/N 414A0634 N675SPPlane Fun Aviation LLC · Bradenton, FLBuilt 2002 · S/N 0378 N675WHayes Richard J · New Smyrna Beach, FLBuilt 2003 · S/N 0537 N67607Bertrand William DBA · Milford, MIBuilt 1980 · S/N E-1750 N6761RPerini Mark J · Greenleaf, IDBuilt 1966 · S/N T210-0161 N6765THyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0629 N67664Hukill Ryan R · Eagle Point, ORS/N 340A1534 N6769RDomingues Silvio · Woodland, ALBuilt 1966 · S/N T210-0169 N676KMAviation Trust Company LLC · Oklahoma City, OKBuilt 2017 · S/N E-4105 N676MFCoastal Resource Associates Inc · Christiansted, VIBuilt 1971 · S/N 402B0106 N676VTYocham Scott · Mcgregor, TXBuilt 2014 · S/N E-4022 N6777RMarsh John E · Washington, DCS/N T210-0177 N6778MNikodem Daniel E · Lakeland, TNBuilt 1977 · S/N 21061990 N6778NMountain Skylane LLC · Loveland, COBuilt 1983 · S/N E-2127 N67799Piper Arrow LLC · Yarmouth, MEBuilt 1984 · S/N EA-433

Back to AD 86-13-04 R3