OpenAirDocs.org
AD 86-13-04 R3

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
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.

N55TMThomas Kurtis · Lubbock, TXBuilt 1978 · S/N TH-901N55TZBoswell Rick · Bartlesville, OKBuilt 1977 · S/N TE-1115N55VSSkie Flying Club LLC · Campbell, CAS/N CE-1305N55WRNeumann Capital Holdings LLC · Bossier City, LABuilt 1965 · S/N D-7799N55WYCentury White Worldwide Inc · Casper, WYBuilt 1966 · S/N TE-241N55YBLockhart John E · Phoenix, AZBuilt 1967 · S/N TE304N55ZZMaxson Lee V · Mesa, AZBuilt 1966 · S/N TE-133N5600KHurta Jennifer Nelsen · Cypress, TXBuilt 1964 · S/N D-7369N5601SArno Aero LLC · Merton, WIBuilt 1966 · S/N D-8152N5602SRegistered aircraftBuilt 1966 · S/N D-8153N5604KX-Country Ventures LLC · Usafa, COBuilt 1964 · S/N D-7459N5604SThrasher Luke DBA · Amarillo, TXBuilt 1966 · S/N D-8156N5605SDevereaux Saw Mill Inc · Pewamo, MIBuilt 1966 · S/N D-8319N5609SSimply Living LLC · Fort Myers, FLBuilt 1990 · S/N CE-1454N560BBSednal Enterprises · Los Gatos, CABuilt 1994 · S/N EA-562N560CDKlohn Volker · Houston, TXBuilt 2005 · S/N 1644N561Jacobsen John O · Prescott, AZS/N TE-918N5610KAdams Timothy C · Ozark, ALBuilt 1964 · S/N D-7378N5610SJager Rylan W · Indn Hbr Bch, FLBuilt 1966 · S/N D-8177N5611SHenry Daniel · Paris, TXBuilt 1966 · S/N D-8150N5614KSherwood George R · Burlington, KYBuilt 1964 · S/N D-7375N5614RLedvina Jay K · Mechanicsburg, PABuilt 1989 · S/N CE-1414N5614SShaughnessy William · Rochester, MNBuilt 1966 · S/N CE-48N5615KDennmark Air LLC · Dighton, KSBuilt 1964 · S/N D-7377N5615SBradley A Eli Dental Corp · Encinitas, CABuilt 1966 · S/N CE-49N5616SVanel Clyde · Cambria Heights, NYS/N D-8158N5617CRoot Griffin W · Fayetteville, GABuilt 1990 · S/N CE-1428N5618KLundin Michael D · Magnolia, DEBuilt 1964 · S/N D-7379N5618SAnnable John W · Pls Vrds Pnsl, CAS/N TE-139N5619KGood Natured Creations LLC · Tucson, AZS/N D-7380N561CDGainesville Aircraft Sales Inc · Gainesville, FLS/N 1640N5621ZJon Air LLC · Dover, DES/N CE-1463N5624KWilson Robert J Jr · Gaithersburg, MDBuilt 1964 · S/N D-7382N5624SKin-Air Inc · Hendersonville, TNFirst renewal noticeBuilt 1966 · S/N D-8168N5625KChung Thomas · Stanwood, WABuilt 1964 · S/N D-7385N5628LRegistered aircraftBuilt 1990 · S/N CE-1460N5629SMostafa Nagy Hassan · Oceanside, CABuilt 1966 · S/N CE-50N562CDFeldman Thomas · Renton, WABuilt 2004 · S/N 1198N562DGB2d LLC · Wickenburg, AZBuilt 1976 · S/N 21061684N562ELMirman Charles B · Pinehurst, NCBuilt 1970 · S/N D-9174N562USua LLC · Artesia, NMBuilt 1968 · S/N TE-562N562YDion William · Coupeville, WABuilt 1991 · S/N E-2633N5630SBell Steve · Broken Bow, OKBuilt 1966 · S/N CE-51N5631SThompson Clay · Altus, OKBuilt 1966 · S/N CE-52N5632SRutherford Keith D · Bossier City, LABuilt 1966 · S/N TE-161N5633SQualitair LLC · MichelstadtBuilt 1966 · S/N D-8330N5634QLegacy Aero LLC · Jonesboro, ARBuilt 1990 · S/N TH-1598N5635SRhodes Stephen · Hayti, MOBuilt 1966 · S/N D-8174N5636GTres Locos Gringos LLC · Lubbock, TXBuilt 1990 · S/N TH-1586N5637SSzarek Carson · San Diego, CABuilt 1966 · S/N D-8160
Back to AD 86-13-04 R3