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.

N24331Registration Pending · Norman, OKRegistration pendingBuilt 1977 · S/N 15280219N24333Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280220N2433DDh Communications Inc · Blairsville, GABuilt 1979 · S/N 18266967N2433GHunt George P · Kamiah, IDBuilt 1959 · S/N 51733N2433RRohrer Walter J · Gallatin, TNS/N 18255533N2433YWheeler Dean S · Lebanon, ORS/N 17249733N2434CGoad Graham L · Mcminnville, ORBuilt 1954 · S/N 30734N2434DHess Joel M · Allenwood, PABuilt 1952 · S/N 20586N2434FHanson Inc · Kalispell, MTS/N 18051634N2434JSkyhawk Aero LLC · Montevideo, MNS/N 15065534N2434LWeston Torey C · Unionville, MOBuilt 1966 · S/N 17255634N2434USkyhawk N2434u LLC · Wilmington, DEBuilt 1963 · S/N 17250034N2434XJensen Shaun V · Anchorage, AKBuilt 1965 · S/N 18256334N24351426th Aero Squadron LLC · Cropwell, ALBuilt 1977 · S/N 15280230N2435DThibodeau Dean U · North Pole, AKBuilt 1952 · S/N 20587N2435FBas Part Sales LLC · Greeley, COS/N 180-51635N2435GVoninski John R · Manlius, NYS/N 51735N2435JWitherspoon Jason C · Austin, ARBuilt 1966 · S/N 15065535N2435LAero Science International LLC · Augusta, GABuilt 1966 · S/N 17255635N2435QVolare Aviation LLC · Wylie, TXBuilt 1966 · S/N 18257635N2435UGalati Stephen E · Florissant, MOBuilt 1963 · S/N 17250035N24363Sale Reported · Crystal, MNSale reported, canceledBuilt 1977 · S/N 15280235N24364Monsalve Carlos M · Lewiston, NYBuilt 1977 · S/N 15280236N2436CHawk Unlimited LLC · Kalispell, MTS/N 30736N2436DSutton Aircraft Salvage LLC · Palmer, AKS/N 20588N2436GDk Futures LLC · Reno, NVBuilt 1959 · S/N 51736N2436RSilva Gary · Yerington, NVBuilt 1964 · S/N 18255536N2436SCranney Dan Gordon · Sevier, UTBuilt 1967 · S/N 337-0736N24373Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280240N2437CFogleman Brian L · Stonewall, LAS/N 30737N2437FKuersten Robert S · Middleton, WIBuilt 1965 · S/N 18051637N2437RBlackwelder John W · Columbia, KYBuilt 1964 · S/N 18255537N2437UPlanetosea LLC · Doylestown, PABuilt 1983 · S/N 21064782N2437XLudke Arnold · Oakland, NJBuilt 1965 · S/N 18256337N2437YRussell John D · Dana Point, CABuilt 1962 · S/N 17249737N24385Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1977 · S/N 15280248N2438GWk Aviation LLC · Buffalo, SDBuilt 1959 · S/N 51738N2438JVayner Anton · Shorewood, WIBuilt 1966 · S/N 15065538N2438UThweatt Greg K · Lodi, CABuilt 1963 · S/N 17250038N2438XRousser Cattle LLC · Amarillo, TXBuilt 1965 · S/N 18256338N2438YHoskins Aaron C · Cayuga, NYBuilt 1962 · S/N 17249738N24399Lcc North LLC · Freehold, NJBuilt 1977 · S/N 15280252N2439GJ+J Electric LLC · Seminole, TXBuilt 1959 · S/N 51739N2439JHenderickson Robert T · Galesburg, ILBuilt 1966 · S/N 15065539N2439LBetts William B · Big Lake, AKS/N 17255639N2439USmith Steven T · Charlottesville, VABuilt 1963 · S/N 17250039N2439XAlpha Aero LLC · Biddle, MTBuilt 1965 · S/N 18256339N2439YBluegate Engineering LLC · Richburg, SCBuilt 1962 · S/N 17249739N243BDBennett Reed J · Reno, NVBuilt 1956 · S/N 20591N243MBSwanson Timothy J · Bannister, MIBuilt 1967 · S/N 337-0813
Back to AD 87-20-03 R2