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.

N3323DPrince Christopher E · Anchorage, AKBuilt 1955 · S/N 32121N3323FFly The Dream LLC · Sun Prairie, WIBuilt 1966 · S/N 18257323N3323JRichards Amy L · Union City, INBuilt 1966 · S/N 15066023N3323RD&J Air Adventures Inc · Koloa, HIBuilt 1967 · S/N 18258623N3323TDeese James K Jr · Charlotte, NCS/N 17700623N3323YMiellerie LLC · Bridgeport, TXBuilt 1962 · S/N 18254323N33247R House Leasing LLC · Stormville, NYBuilt 1975 · S/N U20602692N33248Wilson Harvey Lee · Gadsden, ALBuilt 1976 · S/N 177RG0932N3324UHaer Welton · Craig, MOBuilt 1963 · S/N 18254724N3324YVoge Michael · Chino Hills, CABuilt 1962 · S/N 18254324N3325RDresick Farms Inc · Huron, CABuilt 1968 · S/N 18258625N3325UWeber Donald E · Saint David, AZS/N 18254725N3326FRegistered aircraftBuilt 1966 · S/N 18257326N3326RAnderson Patrick Alan · Ripley, WVS/N 18258626N3326TGallman Doug M · Port Orange, FLBuilt 1967 · S/N 17700626N33272Explorco LLC · Evergreen, COBuilt 1976 · S/N 177RG0938N33273Dahl Neil A · Arlington, TXBuilt 1976 · S/N 177RG0939N33274Cooker Brian M · Gold Hill, NCBuilt 1976 · S/N 177RG0940N33277Niebuhr Bradley A · Morriston, FLS/N U20602708N3327DWelborn Mark G · Boonville, NCFirst renewal noticeS/N 32125N3327GWhitewater Aviation Inc · Harrison, OHBuilt 1972 · S/N 17261224N3327RLyman Gregory A Trustee · Traverse City, MIBuilt 1967 · S/N 18258627N3327SDavis Blake A · Bellevue, TXS/N 21059127N3327TFriedl Robert Stephen Jr · Mammoth Lakes, CAS/N 17700627N3328DAcme Aircraft Leasing Mt LLC · Kalispell, MTBuilt 1955 · S/N 32126N3328ENorthwoods Air LLC · Orono, MES/N 17271505N33291Skyways Aviation Inc · Wilmington, DEBuilt 1976 · S/N 177RG0944N33296Mob Aviation USA LLC · Auburndale, FLBuilt 1976 · S/N 177RG0946N33297Skinner Marvin L · Mansfield, TXBuilt 1976 · S/N 177RG0947N33299Business Jet Services Inc · Apopka, FLBuilt 1976 · S/N 177RG0948N3329DWarren Mark W · Arlington, WABuilt 1955 · S/N 32127N3329ERichards Erick F · Stamford, TXS/N 18268242N3329FFerguson Ryan L · Fort Collins, COBuilt 1966 · S/N 18257329N3329UDirectional Holdings LLC · Missoula, MTBuilt 1963 · S/N 18254729N332DGRaymond Jeffrey R · Fairbanks, AKBuilt 1976 · S/N 18503043N332JCS&S Aircraft Inc · Bennington, VTS/N 17258514N332JRAdair Lawrence L Jr · Fountain Run, KYBuilt 1961 · S/N 18253722N333Grullon Guarocuya · Van Buren Twp, MIBuilt 1980 · S/N A1520963N3330DState Of Alaska · Kodiak, AKBuilt 1955 · S/N 32128N3330EJarco Air LLC · Fitchburg, MABuilt 1978 · S/N 17271507N3330FEmk Trans LLC · The Dalles, ORS/N 18257330N3330JDownwind Three Six LLC · Murfreesboro, TNBuilt 1974 · S/N 18263456N3330UWolford Alyson · Bonney Lake, WABuilt 1963 · S/N 18254730N3330YTighe Joseph E · Kingsland, TXBuilt 1962 · S/N 18254330N3331DKramer Donald J · Buffalo, MNBuilt 1955 · S/N 32129N3332SFluckey Gary T · Homer, AKS/N 18502274N3332TWilliams Darryl L · Medina, OHS/N 17700632N3332UMing Greg A · Guymon, OKBuilt 1963 · S/N 18254732N3333JUrban Aviation Services Inc · Paxton, MABuilt 1966 · S/N 15066033N3333YDeville Charles D · Clinton, LABuilt 1962 · S/N 18254333
Back to AD 87-20-03 R2