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.

N9233WMount Up Aviation LLC · Kirbyville, MOBuilt 1967 · S/N 28-10901N9233ZCalmwinds LLC · Middletown, DEBuilt 1993 · S/N 3213062N9234ACruz Salvador A · Sumter, SCS/N 21001CN9234ELdg LLC · Kalispell, MTBuilt 1992 · S/N 14033CN9234KUnusual Attitudes LLC · Stow, OHBuilt 1976 · S/N 28-7690232N9234MRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1966 · S/N 1189N9234WRutledge Brent E · Uvalde, TXBuilt 1967 · S/N 28-10902N9234ZIovanna Steven · Plymouth, MABuilt 1995 · S/N 2811041N92356Hub City Aviation Academy LLC · Lubbock, TXBuilt 1973 · S/N 17261567N9235CWilliams Patrick S · Saint Paul, MNBuilt 1978 · S/N 28-7890392N9235PJen Lyn Inc · Wilmington, DEFirst renewal noticeBuilt 1967 · S/N 24-4734N9235QInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N 3213072N9235SKaidor Jerome L · Hayward, CABuilt 1975 · S/N M-1727N9235VLott William F Jr Trustee · Oklahoma City, OKBuilt 1969 · S/N 690051N9235YKamasano LLC · Highland, CABuilt 1983 · S/N 31P-8414020N92362Yeakley Gary G · Ontario, CABuilt 1993 · S/N 19006CN9236CRudloff Uwe K · Lake Village, INBuilt 1978 · S/N 28R-7837181N9236EPorch Brock J · Philip, SDBuilt 1977 · S/N 7142CN9236HOptic Air LLC · Sioux Center, IABuilt 1975 · S/N 17266034N9236JThunderbird Air LLC · Grand Rapids, MIBuilt 1993 · S/N 3213067N9236KLabrada Fabio · Decatur, TXBuilt 1976 · S/N 28-7625172N9236NWilliams Robert J · Sewickley, PABuilt 1993 · S/N 3213068N9236PTasso Aviation LLC · Orrville, ALS/N 24-4735N9236SMahi Aviation Corp · Winter Garden, FLNon-citizen corporation, flight hours not reportedBuilt 1975 · S/N M-1728N9236VYeske Brock Ray · Peoria, ILBuilt 1993 · S/N 3213069N9236WSchmidt Robert · Winchester, WIBuilt 1967 · S/N 28-10905N9236YSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 19008CN9237JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1989 · S/N 2841123N9237PCloud Climibers LLC · Lexington, KYBuilt 1967 · S/N 24-4736N9237VPortouw Lawrence J · Huachuca City, AZBuilt 1969 · S/N 690058N9237WDoyle Michael J II · Wakeman, OHBuilt 1967 · S/N 28-10877N9238Cronite Global Corp · Parsippany, NJBuilt 1974 · S/N 229N9238KCrow Wing Flying Club Corp · Nisswa, MNFirst renewal noticeBuilt 1976 · S/N 28-7690233N9238NBloomberg David C · Northampton, MABuilt 1993 · S/N 19012CN9238PPylant Eric Jon · Arnold, CABuilt 1967 · S/N 24-4737N9238RBruce Ronald · Momence, ILBuilt 1993 · S/N 15003CN9238SAllt International LLC · Parker, COBuilt 1976 · S/N M-1760N9238WMansour Muhamad A · Wichita, KSBuilt 1967 · S/N 28-10908N92390Elek LLC · Springfield, MOBuilt 1994 · S/N 2811045N9239DMisson Aviation LLC · Lima, OHBuilt 1994 · S/N 3213071N9239JAshmore Benjamin H Jr · Austin, TXBuilt 1966 · S/N 28-3313N9239NRd Aviation LLC · Fort Lauderdale, FLBuilt 1993 · S/N 3213070N9239SRoyer Richard W · Winnebago, MNBuilt 1975 · S/N M-1732N9239VRegistration Pending · Louisville, MSRegistration pendingBuilt 1969 · S/N 690059N9239WBenrud Jeffrey S · Raeford, NCBuilt 1967 · S/N 28-10909N9239YDelgado John F · San Antonio, TXBuilt 1984 · S/N 31P-8414040N923ACWarnock Tony J · Mobile, ALBuilt 1990 · S/N 42N923AMEdburg Stanley L · Mead, WABuilt 2005 · S/N 001N923DBGrenville Andrew · Decatur Island, WABuilt 2002 · S/N 18281087N923DMHt Holdings LLC · Oxford, MSBuilt 2004 · S/N 18281496
Back to AD 87-10-06 R1