AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N6645WHolman Robert S · Delta, UTBuilt 1965 · S/N 28-20745N6646HIowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1975 · S/N 17265523N6646JNoize Farm Inc · Cheyenne, WYBuilt 1968 · S/N 28-5133N6646WCordova Jesse · Raymore, MOS/N 28-20746N6647UMouton Charles J Jr · Gladewater, TXBuilt 1963 · S/N 142N6647WPanama Truck Line LLC · Florissant, MOBuilt 1965 · S/N 28-20748N6647YSkyway Inc · Wilmington, DEBuilt 1968 · S/N 27-3880N6648PAnkrom Lloyd Paul · Manasquan, NJBuilt 1960 · S/N 24-1770N6649JBowline Ray D · Salina, OKBuilt 1968 · S/N 28-5064N6649UKuykendall William · Yantis, TXBuilt 1963 · S/N 144N664AKWarren John · Homer, AKBuilt 1975 · S/N 17702148N664FLElon Aviation LLC · Burlington, NCBuilt 1971 · S/N 28-7125586N664HBraddock Douglas S · Limestone, TNBuilt 1999 · S/N 14664N664JFFarrell Jeremiah E · Burnsville, MNBuilt 2008 · S/N 82261N664PBThomas Anthony Robert Jr · Frederick, MDBuilt 1998 · S/N 18280156N664RRobertello Gerald J · Centreville, VABuilt 1960 · S/N 39082N664RSMalibu Inc · Dover, DEBuilt 2000 · S/N 4636313N664SBRv Air LLC · Leander, TXBuilt 2002 · S/N 25176N664TJEddleman John C · White Rock, NMBuilt 1991 · S/N 664N664WBilliar Michael E · Independence, ORBuilt 2004 · S/N 60036N665Hamrick Gary L · Willshire, OHBuilt 1973 · S/N 28-7410034N6650JCarolian Aviation LLC · Bexley, OHBuilt 1968 · S/N 28-5076N6650PAnderson Gregory · Acworth, GABuilt 1960 · S/N 24-1773N6650ULarson Reid A · Medford, MABuilt 1963 · S/N 145N6650WCole Alexander G · Leander, TXBuilt 1965 · S/N 28-20751N6651RZucha Joseph P · Rio Vista, CABuilt 1975 · S/N MB-742N6651UWilliams Jerry L · Cortez, COBuilt 1963 · S/N 146N6652GHenehan Brendan A · Geneva, NYBuilt 1983 · S/N M-2385N6652PKlapstein Nancy M · Sweet Grass, MTNon-citizen corporation, flight hours not reportedS/N 24-1775N6652WLumley John J · Delray Beach, FLBuilt 1965 · S/N 28-20754N6653LDempsey Christopher S · Ponderay, IDBuilt 1969 · S/N 416N6653URevisky Veronica F · Minooka, ILBuilt 1963 · S/N 148N6654FRed River Aviators Flying Club · Bossier City, LAS/N 28-7715173N6654HBertapelle Joseph R · Derby, KSBuilt 1975 · S/N 17265525N6654PBaldwin Gary S · Prescott, AZBuilt 1960 · S/N 24-1777N6654UHarbison Aerospace LLC · Whites Creek, TNBuilt 1963 · S/N 149N6654WKosko Stanley G · Seattle, WABuilt 1965 · S/N 28-21279N6655HDonner Ronald W · Northfield, MNBuilt 1994 · S/N 294N6655JLaukkanen Heikki J · Camas, WABuilt 1968 · S/N 28-5139N6655PHensley George T · Telford, TNBuilt 1960 · S/N 24-1778N6655UL & L Aviation LLC · Sidney, NES/N 150N6655W5b Aviation LLC · Duncan, OKS/N 28-20757N6656APike/Kelley LLC · Eureka Springs, ARBuilt 1983 · S/N MC-792N6656HCasey Thomas J · Fernandina, FLBuilt 1981 · S/N 18267895N6656JFauber Clifford W · Cincinnati, OHBuilt 1968 · S/N 28-5141N6656PGregory James A · East Burke, VTBuilt 1960 · S/N 24-1779N6656UFanselow Dan L · White Bear Lake, MNBuilt 1963 · S/N 151N6657JRegistration Pending · Tavares, FLRegistration pendingS/N 28-5142N6657PMiller Aaron M · Scottsdale, AZBuilt 1960 · S/N 24-1780N6657WKlienstuber James D · Yamhill, ORBuilt 1965 · S/N 28-20760
Back to AD 87-10-06 R1