AD 87-20-03 R2

Registered aircraft · 54,015

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.

N9191GFischer Gary H · Savannah, GAS/N 18260731N9191UN9191u LLC · California, MDBuilt 1976 · S/N 15078142N91925Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17261524N91926Pacific Flying Association LLC · Aurora, ORBuilt 1969 · S/N 18259955N91928Moseley Michael S · Chelsea, ALBuilt 1969 · S/N 18259957N9192CBellamy Mark A · Freeville, NYBuilt 1955 · S/N 31291N9192GWg Aero LLC · Shreveport, LABuilt 1971 · S/N 18260732N9192MHandelin Gary W · Carson City, NVBuilt 1970 · S/N U20601592N91937Munsell Kenneth L · Stuart, FLBuilt 1969 · S/N 18259961N9193ASchlafmann Jay R · Mercer, NDBuilt 1949 · S/N 18954N9193BRegistration Pending · Garwood, TXRegistration pendingBuilt 1958 · S/N 36793N9193GMach One Velocity LLC · Macomb Twp, MIBuilt 1979 · S/N 17273626N9193HPrairie Flyers Flying Club · Eudora, KSBuilt 1975 · S/N 17266006N9193TRich Edward L · Liberty, UTBuilt 1960 · S/N 50693N9193UVan Buskirk Bill J · Wasilla, AKBuilt 1976 · S/N 15078144N91941West Debra C · Dillon, COBuilt 1969 · S/N 18259963N91942Marvelous Margies Flying Club LLC · Helper, UTS/N 18259964N9194AWeathered Brenton W · Poquoson, VABuilt 1949 · S/N 18955N9194GJd Business Services LLC · Denair, CAS/N U20603808N91950Bruno Cosimo Gino · Spokane, WABuilt 1969 · S/N 18259966N91954Suchland Simon K · Fairbanks, AKBuilt 1957 · S/N 50105N91958Greenwood Richard S · Duncan, OKBuilt 1969 · S/N 18259967N91963Justpullin Inc · Wilmington, DEBuilt 1969 · S/N 18259970N9196BPeterson James G · Keller, TXBuilt 1958 · S/N 36796N9196GJohnson Judith A · Sedro Woolley, WABuilt 1971 · S/N 18260736N9196HLaplante Rene J · Bellingham, WABuilt 1975 · S/N 17266008N9196TC9196tango LLC · Kalispell, MTBuilt 1960 · S/N 50696N91976Tucker Bobby G · El Dorado, ARBuilt 1969 · S/N 18259975N91978Dvorak Ross E · Highland, CABuilt 1969 · S/N 18259976N9197AAlmeida Gilbert M · Hilmar, CABuilt 1949 · S/N 18958N9197CWood Steven · Morgan, UTBuilt 1954 · S/N 31296N9197GWheeler Dealer LLC · Wilmington, DEBuilt 1971 · S/N 18260737N9197TRichardson Gordon P · Polson, MTBuilt 1960 · S/N 50697N9197UWarfel Everett E · Greenwood, DEBuilt 1976 · S/N 15078148N91984A-Line LLC · Kent, WABuilt 1973 · S/N 17261532N91987Sander William D · Eaton, COBuilt 1969 · S/N 18259982N9198AMorse Steven J · Gig Harbor, WAS/N 18959N9198CSmith Rickey J · Port Saint Joe, FLBuilt 1954 · S/N 31297N9198GDuckflyway LLC · Herscher, ILS/N 18260738N91999Gembala Randall L · Kalispell, MTBuilt 1969 · S/N 18259990N9199BM & H Investment LLC · Montgomery City, MOBuilt 1958 · S/N 36799N9199MBlue Sky Flyers Inc · Greeley, COBuilt 1976 · S/N 18264739N9199TFv Arianna Sage Inc · Chignik Lagoon, AKS/N 50699N919BGuastadisegni Joseph A Trustee · Oak Hills, CABuilt 1970 · S/N 33701307N919DCDelaware Corp · Topping, VABuilt 1976 · S/N 177RG1055N919EHKauffman Keith · Redondo Beach, CABuilt 1959 · S/N 52391N919HWStonehollow Pain Services LLC · Elizabeth, ARS/N 21060054N919RRodriguez Daniel L · West Linn, ORS/N 21059032N91AAShine Donald J · Waterford, WIBuilt 1971 · S/N 33701382N91AZGulf Coast Helicopters Inc · Pearland, TXS/N 18265784
Back to AD 87-20-03 R2