Registered aircraft · 6,238

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:87-18-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-18-06-R1') 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:87-18-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-18-06-R1')
  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:87-18-06-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-18-06-R1')
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.

N6742LCrook Keigm L · Livingston, TXBuilt 1983 · S/N EA-385 N6742NCrazy Mountains Aviation LLC · Columbus, GAS/N TH-1140 N6742PPrice Paul · Lancaster, VABuilt 1980 · S/N E-1709 N6742SPowers Benjamin · Circleville, OHBuilt 1979 · S/N E-1635 N6743CRocket Ems Inc · Santa Clara, CABuilt 1980 · S/N TJ-269 N6745CTan Industries LLC · Wilmington, DEBuilt 1983 · S/N E-2109 N6745MPerkins Communication LLC · Northport, ALBuilt 1980 · S/N TH-1124 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 N6746TFlying Wolf LLC · Lomita, CABuilt 1980 · S/N E-1674 N6746WEngine House.Com LLC · Corvallis, MTBuilt 1980 · S/N EA-73 N6747JQualitair LLC Trustee · MichelstadtS/N E2130 N6747TYesco Administration LLC · Salt Lake City, UTBuilt 1984 · S/N TH-1403 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 N6749VUsg Assets Inc · Clarkesville, GABuilt 1980 · S/N E-1681 N674DMBravo Aviators LLC · Argyle, IABuilt 1974 · S/N CE-495 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 N67551Takeoff Holdings LLC · Anchorage, AKBuilt 1983 · S/N E-2119 N6755QAeromed 36 LLC · Cedar Rapids, IABuilt 1984 · S/N E-2162 N6756DSarsfield Aviation LLC · Dacula, GABuilt 1980 · S/N TE-1181 N67574International Air Services Inc Trustee · Carson City, NVS/N TE-1194 N6757DMcdonald Land & Cattle LLC · Muleshoe, TXBuilt 1980 · S/N E-1698 N67586Carwashos LLC · Colorado Springs, COBuilt 1983 · S/N EA-397 N6758XAc Green LLC · Athens, OHBuilt 1980 · S/N TK-134 N6759CJds Aero LLC · Decatur, TXS/N E-1686 N6759GTrademark Services LLC · Vineyard Haven, MABuilt 1980 · S/N E-1682 N6759JConrick Charles J IV · Fort Myers, FLBuilt 1984 · S/N CE-1040 N675BWFreedman Stephen Eric · Falls Church, VABuilt 1978 · S/N D-10134 N67607Bertrand William DBA · Milford, MIBuilt 1980 · S/N E-1750 N6764KElemental Energy LLC · Portland, ORBuilt 1983 · S/N E-2102 N676BHTicknor Rodney J · Bridewater, IABuilt 1983 · S/N E-2121 N676GGuest Air LLC · Plains, GABuilt 1980 · S/N TH-1179 N6778NMountain Skylane LLC · Loveland, COBuilt 1983 · S/N E-2127 N67799Piper Arrow LLC · Yarmouth, MEBuilt 1984 · S/N EA-433 N677BEGoodrich Matthew E · Bainbridge Island, WAS/N E-1090 N6780QVaulters Aviation LLC · Coburg, ORBuilt 1984 · S/N E-2128 N6784SSbhd LLC · Santa Rosa Beach, FLS/N E-3089 N6788CDewn Aviation LLC · Noble, OKFirst renewal noticeBuilt 1983 · S/N E-2090 N6789YMcdonough Patrick J · Defiance, OHBuilt 1986 · S/N EA-453 N678EMAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1978 · S/N E-1285

Back to AD 87-18-06 R1