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.

N42LBRigney Timothy D · Troy, VABuilt 1970 · S/N D-9140 N42MDN42md LLC · Ashburn, VABuilt 1999 · S/N 29-0178 N42MMPiper Capital LLC · Elkhorn, NEBuilt 1988 · S/N CE-1278 N42MWWalker Winston W Trustee · Tucson, AZBuilt 1981 · S/N 414A0680 N42NCCapair Inc · Plantation, FLBuilt 1973 · S/N 402B0387 N42SGPolar Star Co · Wilmington, DES/N 4140927 N42SMBaron South LLC · Dexter, MOBuilt 1977 · S/N TJ-109 N42TBFlores Nicholas L Jr · San Antonio, TXBuilt 1998 · S/N TH-1872 N42TVK2 Aviation LLC · Carroll, IABuilt 1998 · S/N 29-0168 N42WBCity Of Mesa Arizona · Mesa, AZBuilt 1981 · S/N P21000667 N42WKMariash Cary Norman · Indianapolis, INBuilt 1964 · S/N D-7390 N42YZPharaoh Aviation LLC · Velma, OKBuilt 1973 · S/N 421B0385 N42ZNHuntsville Flyers LLC · Owens Cross Roads, ALBuilt 2001 · S/N 0042 N4300QFarwell Christopher J Trustee · Olympia, WABuilt 1973 · S/N 18502232 N4300WPrivate Enterprises LLC · Peoria, AZBuilt 1973 · S/N E-487 N4301SCoburn Thomas R Trustee · Upperco, MDBuilt 1975 · S/N CE-578 N4301WNash Matthew · Edmonds, WABuilt 1974 · S/N D-9578 N4302WDagenhart Ronald Jason · Westerville, OHBuilt 1974 · S/N D-9582 N4304CN4304c LLC · Pawhuskah, OKBuilt 1980 · S/N 340A1011 N4305UMarshall Paul A Trustee · Gilroy, CABuilt 2000 · S/N E-3305 N4305WBennett Hugh · Gillette, WYBuilt 1974 · S/N TE-967 N4306AOdyssey Aviation LLC · Raleigh, NCBuilt 1970 · S/N TE-802 N4306WBlaylock Christopher W · Lubbock, TXBuilt 2000 · S/N E-3352 N4307SHuddleston Edward · Oaktown, INS/N E-675 N4308SBurroughs Steven R · Murphysboro, ILBuilt 1975 · S/N E-678 N4308ZMike Victor Yankee LLC · Andover, MABuilt 1983 · S/N T30300183 N4309RWest Atlantic Transportation Corp · Mount Pleasant, NCBuilt 1976 · S/N 18502928 N4309SGsi · Temple, TXBuilt 1975 · S/N E-682 N430FMCygnus Inc · Sioux Falls, SDBuilt 2000 · S/N E-3319 N430RPSale Reported · Billings, MTSale reportedBuilt 1976 · S/N 18503244 N430RVVermejo Aviation LLC · Boulder, COBuilt 2004 · S/N TH-2097 N4310SVelk Vincent F · Havre, MTBuilt 1975 · S/N D-9773 N4312VBaron Be 58 LLC · Essex, MTBuilt 1984 · S/N 46-8408012 N4312WBreitbarth Brian · Canby, ORBuilt 1974 · S/N D-9585 N4314BJab Aviation LLC · Houston, TXBuilt 1982 · S/N CE-1002 N4315COld Salt Aviation LLC · Virginia Beach, VABuilt 1978 · S/N 340A0532 N4316WHolt Bartlett · Binghamton, NYBuilt 1974 · S/N CE-485 N4317WMurray Patrick G · Moraga, CABuilt 1974 · S/N D-9587 N4319MSale Reported · Aptos, CASale reportedBuilt 1983 · S/N 46-8408005 N4319RWoodland William B · Anchorage, AKFirst renewal noticeBuilt 1976 · S/N 18502931 N431CDMother Of Perpetual Succor LLC · Villa Hills, KYBuilt 2005 · S/N 1501 N431CELegacy Aviation LLC · Ann Arbor, MIBuilt 1973 · S/N 414-0431 N431DBDuininck Companies LLC · Prinsburg, MNBuilt 2003 · S/N 29-0288 N4321EHarper Henry Jr · Mesquite, NVS/N D-8868 N4321SBeech Peak Aviation LLC · Boulder, COBuilt 1964 · S/N D-7512 N4321XGrady Auctions & Realty Inc · Newport, ARBuilt 1965 · S/N 21058623 N4322WSnell Steve · Scotts Valley, CABuilt 1974 · S/N D-9589 N4323BBkt Holdings LLC · Mont Belvieu, TXBuilt 1983 · S/N 46-8408009 N4323POverspray LLC · Norfolk, NEBuilt 1983 · S/N 46-8408013 N4324VTriple Aaa LLC · Garden City, KSBuilt 2001 · S/N TH-2014

Back to AD 86-13-04 R3