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.

N4LWWilliams Jason Allen · Cypress, TXBuilt 1992 · S/N TH-1652N4MACoral Key Air Inc · Brookhaven, NYBuilt 1972 · S/N 18502044N4MCCoberly Adrian R · Manhattan, KSBuilt 1984 · S/N TJ-461N4MUBlusky Properties & Investments LLC · Cameron, MOBuilt 1970 · S/N 421B0054N4RMLofgren Kenny G · Redmond, ORS/N U206-0683N4VWPronk Glen R · Crittenden, KYBuilt 1974 · S/N 21060277N4WRShoemaker David J · Menlo Park, CABuilt 1967 · S/N D-8497N4WZMulligan Peter · Richardson, TXBuilt 1970 · S/N TH117N4XCMinnehan Land & Cattle Co · Joplin, MTBuilt 1975 · S/N 18502876N4XPPazdziora Ronald G · St Charles, ILBuilt 1982 · S/N D-10401N4YYWilliams Scott Griffin · Salt Lake City, UTBuilt 1979 · S/N 21063553N4YZLackerdas Harry · Melba, IDBuilt 1977 · S/N U20603702N4ZYValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 1502N5000CFly Right LLC · Burlington, WIBuilt 2004 · S/N 0803N5000UMci Air LLC · Wilmington, DEBuilt 1979 · S/N 414A0318N5001RLe Conte LLC · Anchorage, AKBuilt 1976 · S/N 18502974N5001XVirginia Brian · Maple Grove, MNBuilt 2002 · S/N E-3481N5005JDowding Industries Inc · Eaton Rapids, MIBuilt 1974 · S/N 310R0129N5008CMckenna Kent T · Torrance, CAFirst renewal noticeBuilt 1950 · S/N D-2270N5008JR C Construction Co Inc · Greenwood, MSBuilt 1975 · S/N 310R0132N5009UOrca Flight LLC · Keaau, HIBuilt 2004 · S/N 0847N500AWMcnulty Kim E · Tehachapi, CAS/N 310R0077N500BAKw Plastics · Troy, ALBuilt 1997 · S/N TH-1814N500BMHawkwell Aviation LLC · Stillwater, OKBuilt 1982 · S/N TJ-418N500CHAchiro David P · Truckee, CABuilt 1976 · S/N 310R0734N500CMM & M Aviation LLC · Portsmouth, NHBuilt 1979 · S/N E1505N500CTLac Aero LLC · Liberal, KSBuilt 1981 · S/N 340A1236N500DMFive Delta Mike Inc · Wilmington, DEBuilt 1987 · S/N CE-1122N500EBKaizen Aircraft Holdings LLC · Kalispell, MTBuilt 1977 · S/N 340A0287N500GEStevenson Anesthesia Associates Pc · Wolfforth, TXBuilt 1977 · S/N E-1130N500GGSawtooth Travel Solutions LLC · Twin Falls, IDBuilt 1990 · S/N E-2564N500JLJet-H Inc · Oak Park, CABuilt 1991 · S/N CE-1603N500KBKilo Bravo LLC · Mount Airy, MDS/N TH-2388N500LDJ & H Investment Corp Inc · Columbia, MOBuilt 1979 · S/N TH-1008N500PFHumphries Stephen A · Kingwood, TXBuilt 1964 · S/N D-7484N500QVJands LLC · Broken Arrow, OKBuilt 1979 · S/N 340A0699N500RCWright Mason · Henderson, NVBuilt 2005 · S/N 1680N500SBKostelic Tanner · Alpena, MIBuilt 1973 · S/N E-482N500TJAirbyars LLC · Spartanburg, SCBuilt 1974 · S/N 421B0585N500TLSententia LLC · Highland Park, ILBuilt 1999 · S/N TH-1890N500WN500w LLC · Ashburn, VABuilt 2005 · S/N E-3630N500WPWelker Franklin W · Agoura, CAS/N EA-582N5011XPro Air LLC · Alexandria, LAS/N 185-0033N5013QTesini Allan J · Zephyrhills, FLBuilt 1971 · S/N 340-0008N5014RCooper Flying Inc · Lamesa, TXBuilt 1976 · S/N 18502978N5017UBen Allen LLC · Wilmington, DEBuilt 1963 · S/N 206-0017N5019JFairley Stephen · Petal, MSBuilt 1974 · S/N 310R0139N501CRTarno Suzzan · Avondale, AZBuilt 1973 · S/N 73-30607N501DCExecutive Aviation LLC · Peoria, AZBuilt 1981 · S/N 340A1267N501KPWasson Ronald L · Colleyville, TXBuilt 1974 · S/N TJ-21
Back to AD 86-13-04 R3