OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N3279CHunsucker Michael A · Seguin, TXS/N R18200265N3279DDavies James E · Eagle, IDBuilt 1955 · S/N 32077N3279LDomnarski Michael J · Ware, MABuilt 1967 · S/N 17256179N3279NTips Frederick J III · San Antonio, TXBuilt 1974 · S/N 21060452N3279USchlafmann Jay R · Mercer, NDBuilt 1963 · S/N 18254679N327BWCessna N327bw LLC · Telluride, COBuilt 1974 · S/N 21060166N327CTYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700535N327DMMullin Clint · Lambert, MTS/N 18262924N327HRRd Holdings LLC · Las Vegas, NVBuilt 1979 · S/N 18267468N327JKRudolph Rudi · Cordova, TNBuilt 1976 · S/N R1722003N327KMarsh John E · Washington, DCS/N 185 0418N327LSHeermann Philip D · Albuquerque, NMBuilt 1978 · S/N 182-66407N327LWPerini Stephen Dale · Fayetteville, GABuilt 1959 · S/N 52360N32806Nimsic Thomas L · Carson City, NVBuilt 1976 · S/N 18264943N3280LDobbertin Thomas E · Redlands, CAS/N 17256180N3281DRichardson John David · Willis, TXBuilt 1955 · S/N 32079N3281JRegistration Pending · Oakland, ORRegistration pendingBuilt 1966 · S/N 15065981N3281LWizna LLC · Boca Raton, FLBuilt 1967 · S/N 17256181N3281RNowicki Stanislaw · Cottonwood Heights, UTS/N 15284363N3281SWright Flyers Club · Huber Heights, OHBuilt 1964 · S/N 18255781N3282DLafleur Kerry P · Fort Worth, TXBuilt 1955 · S/N 32080N3282LFranco David F Jr · Santa Rosa, CABuilt 1967 · S/N 17256182N3282SWest Thomas Edward · Watsonville, CABuilt 1964 · S/N 18255782N3282TCavu Aircraft Sales & Management Inc · Olyphant, PABuilt 1967 · S/N 17700582N3283AHarrison Donald R · Lake Havasu City, AZBuilt 1953 · S/N 25927N3283DAllen Roger B · Gardnerville, NVBuilt 1955 · S/N 32081N3283LHill Suzanne L · Edmond, OKBuilt 1967 · S/N 17256183N3284DKornfield Edward A · Anchorage, AKBuilt 1955 · S/N 32082N3284LWill Clifford S · Grayson, GABuilt 1967 · S/N 17256184N3284YMonnin Cass C · East Wenatchee, WAS/N 18254284N3285LDouglass Grant · Rockport, TXBuilt 1967 · S/N 17256185N3285SCastro Manny H · Tucson, AZBuilt 1964 · S/N 18255785N3285VAviate Navigate Communicate LLC · Dewey, AZBuilt 1977 · S/N R1722245N3286JJohnson David W · Biwabik, MNS/N 15065986N3286LEagle Eye Aviation LLC · Meridian, IDBuilt 1967 · S/N 17256186N3287ASpetman Craig Warren · Overgaard, AZS/N 25931N3287EOff Course Aero Ventures LLC · Mechanicsville, VABuilt 1978 · S/N 17271492N3288ABaeten Gerard J · De Pere, WIBuilt 1953 · S/N 25932N3288DSmith James O · Montgomery, TXS/N 32086N3288JSouthern Arkansas University Tech · Camden, ARBuilt 1966 · S/N 15065988N3288SEpple William E · Roggen, COBuilt 1964 · S/N 18255788N3288UVetch Rod F · Ranchester, WYBuilt 1963 · S/N 18254688N32897Mach Point Nine LLC · Phoenix, AZS/N 15065989N3289AKennedy Kelly · Wheatland, WYBuilt 1953 · S/N 25933N3289SDouble Lazy H LLC · Delta, COBuilt 1964 · S/N 18255789N3289URutenbeck Terry L · Wiggins, COBuilt 1963 · S/N 18254689N3289YHasselbring Ted S · Nashville, TNBuilt 1962 · S/N 18254289N328DDLandsburg Custom Services LLC · Sandusky, MIBuilt 1973 · S/N 17262401N328LDuffield Brian · Eastvale, CABuilt 1973 · S/N 18262043N32909Zamarripa Hector · Brownsville, TXBuilt 1970 · S/N 18260423
Back to AD 87-20-03 R2