OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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.

N2806CWells Nick M · Holdrege, NES/N 26349N2806EBexar Aviation LLC · San Antonio, TXBuilt 1978 · S/N 17271328N2806QLawson Lance J · Sikeston, MOBuilt 1971 · S/N 17259806N2806UWeeber Charles · Pelham, MABuilt 1963 · S/N 17250406N2806YPautler Justin H · Alden, NYBuilt 1962 · S/N 18253806N2807AWoodley Aerial Leasing LLC · Walnut, ILBuilt 1953 · S/N 30007N2807EMission One LLC · Excelsior, MNBuilt 1978 · S/N 17271329N2807KLeseberg Mark E · Minden, NVBuilt 1979 · S/N 18053078N2807LBerisha James · Porter, TXS/N 17256007N2807QReynolds David F · Port Orange, FLBuilt 1971 · S/N 17259807N2807UMeese Brian D · Conroe, TXBuilt 1963 · S/N 17250407N2808KCam Corporation · Fairbanks, AKBuilt 1979 · S/N 18053079N2808RInman Matthew · Gallatin, TNBuilt 1967 · S/N 18258408N2809CNixon Ross M · Hillsboro, ORBuilt 1954 · S/N 26352N2809FOverbaugh Gary R · Highland, UTBuilt 1966 · S/N 18256909N2809LWarner Walter M Jr · Willow, AKBuilt 1967 · S/N 17256009N2809RTerwillegar Charles E · Renton, WABuilt 1967 · S/N 18258409N2809UBleskan Erick J · New Berlin, WIBuilt 1963 · S/N 17250409N2809XGuckian Jim J · Riverdale, GABuilt 1967 · S/N 17700209N280HB280hb LLC · Brighton, MIBuilt 1966 · S/N 18256901N280JGEdwards Jonathan S · Marysvale, UTBuilt 1968 · S/N 17700498N280JPDraaisma Jacob Jr · Middleville, MIS/N 50825N280MSM & S Air Service Inc · Honeoye Falls, NYBuilt 1973 · S/N 17261450N280SLRamer Scott A · Dornsife, PAS/N 172-73121N280SWKatie Investments Inc · Little Rock, ARBuilt 1978 · S/N 20604561N2810FDancing On Blue Lc · Las Vegas, NVBuilt 1966 · S/N 18256910N2810KWair Inc · Mount Vernon, WABuilt 1979 · S/N 18053081N2810QMcdowell Kevin J · Williamsburg, VABuilt 1971 · S/N 17259810N2810RSeller Mark E · Hutchinson, MNBuilt 1967 · S/N 18258410N2810SWaco West Inc · Dover, DEBuilt 1967 · S/N 15066710N2810UN2810u LLC · Delray Beach, FLBuilt 1963 · S/N 17250410N2810VDipasquale Glenn D · Gloversville, NYBuilt 1974 · S/N 15076288N2811CBeyer James C · Fayetteville, TNBuilt 1954 · S/N 26354N2811FLien Craig C · Plains, MTBuilt 1966 · S/N 18256911N2811KHayward Houston C · Lansdale, PABuilt 1979 · S/N 18053082N2811YCotti Kevin P · Plymouth, MABuilt 1961 · S/N 18253811N2812CSmallwood Nathan M · Ellicott City, MDS/N 26355N2812KSylvester John A · Hereford, AZBuilt 1979 · S/N 18053083N2812LHarris Partnership · Conway, ARBuilt 1967 · S/N 17256012N2812QHammond David J · Chesterfield, VABuilt 1971 · S/N 17259812N2812RBullin Keith · Bryan, TXBuilt 1967 · S/N 18258412N2812UBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 17250412N2812XHarris Rodger C · Titusville, FLBuilt 1967 · S/N 17700212N2813CFray Jonathan C · Wasilla, AKBuilt 1954 · S/N 26356N2813FDan Air LLC · Greenville, SCBuilt 1966 · S/N 18256913N2813LFoster Neal W · Nome, AKBuilt 1967 · S/N 17256013N2813QOriginal Design Ministries · Eatonville, WABuilt 1971 · S/N 17259813N2814CStone Robert D · Anchorage, AKBuilt 1954 · S/N 26357N2814KMacario Mark A · Weirsdale, FLBuilt 1979 · S/N 18053085N2814LStewarts Aircraft Service Inc · Waynesville, OHBuilt 1967 · S/N 17256014
Back to AD 87-20-03 R2