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.

N6161ZSkybound Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0019 N6162CHeller Casey · Williston, NDBuilt 2003 · S/N 0619 N6162RSmjd LLC · Penrose, COBuilt 1965 · S/N T210-0062 N6162XCapital Holdings 149 LLC · Kearney, NEBuilt 2005 · S/N 1371 N6163RSai Flight Services Inc · Greer, SCBuilt 1981 · S/N E-1967 N6163UMcevoy Steven T · Aniak, AKBuilt 1980 · S/N U20605357 N6165FMainely Lobsters · Gulf Breeze, FLBuilt 1968 · S/N 21059065 N6166NBrian C Haggerty LLC · Pembroke Pines, FLBuilt 1981 · S/N 18504302 N6166UBb Aviation LLC · Prescott, AZBuilt 1979 · S/N U20605359 N6167CSnyder Larry G · Holland, NYBuilt 1979 · S/N 21063818 N6167NMillhorn Farms Inc · Worley, IDS/N 18504303 N6168NRegistered aircraftBuilt 1978 · S/N 21062939 N6169FWatrud Joel Carl · Waskish, MNS/N 21059069 N616ASBrozzo Ralph A · Midland, MIBuilt 2005 · S/N 1428 N616CDInnovative Aviation LLC · Filer, IDBuilt 1973 · S/N CE-455 N616CWDixie Air LLC · Russell Springs, KYBuilt 2005 · S/N 1620 N616DFugate Kirk A · El Dorado Springs, MOS/N 421B0140 N616GROld Goat Aviation LLC · Chattanooga, TNS/N TJ-184 N616JHHarcatco LLC · Corsicana, TXS/N 18504290 N616MSBledsoe Bobby H · Hot Springs, ARS/N 40047 N616RMMnemonics Inc · Melbourne, FLBuilt 1973 · S/N 414-0375 N616STK&S Flights LLC · Sweet Valley, PABuilt 1981 · S/N 414A0806 N6170FWilkins Raymond E · Osceola, IABuilt 1968 · S/N 21059070 N6170NGarmin210 LLC · Willard, MOBuilt 1978 · S/N 21062941 N6170RBrown Michael R · Huntsville, ALBuilt 1965 · S/N T210-0070 N6171FDohrenwend Mark G · Owensboro, KYBuilt 1968 · S/N 21059071 N6171ZTennessee Valley Aviation LLC · Fayetteville, TNBuilt 2003 · S/N 0635 N6173FLesondank Stephen M · Bellvue, COBuilt 1968 · S/N 21059073 N6173RBeyer Livestock Auction LLC · Clovis, NMBuilt 1965 · S/N T210-0073 N61742Fox James R · Saint Paul, MNBuilt 1981 · S/N 18504246 N61747Lakes Aircraft LLC · Little Canada, MNBuilt 1981 · S/N 18504248 N61749Kellogg Wade A · Chelsea, MIBuilt 1981 · S/N 18504249 N6174BN6174b LLC · Nokomis, FLBuilt 1978 · S/N 21062698 N6175RElinoff Neal D · Telluride, COBuilt 1965 · S/N T210-0075 N6176RJulius Kaleb · Mesa, COBuilt 1965 · S/N T210-0076 N6176UHallman David M Jr · Erie, PABuilt 1981 · S/N D-10387 N6176XCentral Texas College · Killeen, TXFirst renewal noticeBuilt 1978 · S/N 310R1315 N6177XMayhew William D · Round Lake, ILBuilt 1978 · S/N 310R1316 N6178WBlu Sky Key West LLC · Key West, FLBuilt 1981 · S/N P21000724 N617JMTravland Christopher · Austin, TXBuilt 1976 · S/N 76-30845 N617MBKlinger Ronald S Trustee · Olympia, WABuilt 1977 · S/N 18503316 N617PTSmart Motion Aviation LLC · Frisco, TXBuilt 1979 · S/N TH-1043 N6180BNewton Raymond C Jr · Heath, TXBuilt 1978 · S/N 21062699 N6180CBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 1978 · S/N 310R1318 N6180NMargiotta Russell A Trustee · Woodside, CABuilt 1978 · S/N 21062951 N61811Schok Jr Richard N · Fairbanks, AKBuilt 1981 · S/N 18504259 N6181C6181c LLC · Saginaw, MIBuilt 1978 · S/N 310R1320 N6181UAndrew Investment Company LLC · Atoka, OKBuilt 1981 · S/N E-1970 N6181ZDittrich James G · Anchorage, AKBuilt 1981 · S/N U20606178 N6182XHillman Paul L · Cleverdale, NYBuilt 1981 · S/N E-1971

Back to AD 86-13-04 R3