Registered aircraft · 18,495

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.

N9776YShinn William K · Newburgh, INBuilt 1981 · S/N 21064595 N977AGFlying T Farms LLC · Callao, MOBuilt 1966 · S/N TE-116 N977GGAds Logistics LLC · Twin Falls, IDBuilt 1977 · S/N U20603828 N977JLLabrie James R · Southampton, MABuilt 1979 · S/N CE-872 N977KMBusse Steve T · Cincinnati, OHFirst renewal noticeBuilt 1964 · S/N D-7366 N977SMKmc Aviation Leasing LLC · Indianapolis, INBuilt 1974 · S/N 421B0595 N977VCross Richard Laurence · Terre Haute, INBuilt 1966 · S/N TE-111 N9780VCountry Aero LLC · Darwin, MNBuilt 1966 · S/N 188-0230 N9782ERegistered aircraftBuilt 1977 · S/N 77-30858 N9787ELagrelius Thomas W · Torrance, CABuilt 1976 · S/N 76-30846 N978GKFox Whiskey Inc · Wilmington, DEBuilt 1996 · S/N E-3047 N9791GAndreshak Thomas G · Bowling Green, OHBuilt 1977 · S/N U20603830 N9792EGardiner Steve · Elora, TNS/N 76-30816 N9793ERichards Edwin A · Buckeye, AZBuilt 1975 · S/N 75-30794 N9794MYr-Aircraft Leasing LLC · Bethel, AKBuilt 1981 · S/N 20700730 N9798RMarine Aviation Museum Inc · Wilmington, DEBuilt 1960 · S/N D-6330 N9798ZWright Air Service Inc · Fairbanks, AKBuilt 1982 · S/N U20606665 N979DMStarnes James W · Beaufort, SCBuilt 1978 · S/N TE-1132 N979MAMeisner Aircraft Inc · Burlington, WIBuilt 1978 · S/N E-1294 N979NAC'Est La Vie LLC · Traverse City, MIBuilt 2008 · S/N E-3857 N979SRBlackstone Real Property LLC · Fargo, NDBuilt 2015 · S/N TH-2435 N979SSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N TH-1932 N97AHKw Air LLC · Fallbrook, CABuilt 1980 · S/N EA-107 N97AQKhag Aviation Inc · Woodbridge, NJFirst renewal noticeBuilt 1977 · S/N 4040135 N97BJRegistration Pending · Dublin, TXRegistration pendingBuilt 1966 · S/N D-8218 N97BKA&D Machinery LLC · Hartsville, SCBuilt 1996 · S/N E-3064 N97CTBarj Associates Co · Naples, FLBuilt 2001 · S/N 0128 N97DFFlying G Aviation LLC · Elizabeth, COBuilt 1978 · S/N 340A0510 N97DSWmg Aviation LLC · Ketchum, IDS/N 18504173 N97DWWestphal Dana L · Broussard, LABuilt 2008 · S/N L2K-165 N97EKern County Sheriffs Department · Bakersfield, CABuilt 1983 · S/N 21064788 N97FAJalbert John E · Greenville, MEBuilt 1982 · S/N 18504373 N97FCParker Cullen B · San Antonio, TXBuilt 1962 · S/N 18051106 N97GWLeft Coast Transport LLC · Largo, FLBuilt 1977 · S/N E-1143 N97HCAlpha Whiskey 1 LLC · Brandon, MSBuilt 1976 · S/N 310R0651 N97JKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1978 · S/N 414A0052 N97LMCarpenter Preston Fant Trustee · Wiggins, MSBuilt 2020 · S/N E-4135 N97LTWallace James R Jr · Oneonta, ALBuilt 2003 · S/N 0768 N97MWagenaar Lucas · Frankston, TXBuilt 1966 · S/N 302 N97NALa Selva John G · Port Saint Lucie, FLBuilt 1976 · S/N NAV-4-2558 N97PWKelley Larry A Jr · Port Arthur, TXBuilt 1994 · S/N 29-0013 N97RGArmy Aviation Heritage Foundation · Hampton, GAS/N TF-20 N97RJN97rj Airplane LLC · Leesburg, VABuilt 2004 · S/N 1151 N97SRMoler Alan D · Valley Center, KSBuilt 1997 · S/N 1 N97STRegistration Pending · Hubertus, WIRegistration pendingBuilt 1996 · S/N 29-0101 N97VCSababa Aviation LLC · West Palm Beach, FLBuilt 1985 · S/N TJ-495 N97VKMore Less 7vk LLC · Lewes, DEBuilt 1997 · S/N LIV-247 N97WBBowditch Harold W Jr · Lancaster, PABuilt 1967 · S/N D-8386 N97WSPrestige Worldwide Enterprises LLC · Germantown, TNBuilt 1979 · S/N E-1433 N9802ZBig Horn Aviation Group · Fort Worth, TXBuilt 1982 · S/N U206-06667

Back to AD 86-13-04 R3