AD 91-10-01

Registered aircraft · 249

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:91-10-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-10-01')
  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.

N340RCConsumer Aviation Inc · Springfield, MOS/N 340B-340N342JCAviation Investments Inc · Redondo Beach, CAS/N 340A-030N346AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 340B446N346CJBank Of Utah Trustee · Salt Lake City, UTS/N 340B-346N348AGAviation Inventory Resources Inc · Alvarado, TXBuilt 1998 · S/N 340B-448N34HGUnited States Government · Fort Belvoir, VAS/N 34N351AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 340B445N351TATrans Executive Airlines Of Hawaii Inc · Honolulu, HIBuilt 1989 · S/N SH3759N352CJAviation Inventory Resources Inc · Alvarado, TXBuilt 1993 · S/N 340B-352N353PAAersale Inc · Coral Gables, FLS/N 20622N353SABank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 340B-351N355CLRegistration Pending · Statesville, NCRegistration pendingS/N 340B-355N360ABAcc Integrated Services Inc · Milwaukee, WIBuilt 1989 · S/N SH3756N361CLLegends Cargo Aircraft LLC · Lakeland, FLBuilt 1994 · S/N 340B-361N362AGJahn362ag LLC · Miami, FLBuilt 1998 · S/N 340B-438N364PXFloat Alaska Holdings LLC · Pomona, CAS/N 340B-262N367ACAcc Integrated Services Inc · Milwaukee, WIBuilt 1983 · S/N SH3626N367MQAcc Integrated Services Inc · Milwaukee, WIBuilt 1982 · S/N SH 3640N369PXAviation Inventory Resources Inc · Alvarado, TXS/N 340B-295N377MQAcc Integrated Services Inc · Milwaukee, WIBuilt 1986 · S/N SH3699N378MQAir Cargo Carriers LLC · Milwaukee, WIBuilt 1986 · S/N SH3700N381MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3703N382MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3704N383MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3706N385MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3707N391RCIal Corp · Lewes, DES/N SH3665N399CLBeta Fleet LLC · South Burlington, VTBuilt 1996 · S/N 340B-399N413XJAviation Inventory Resources Inc · Alvarado, TXFirst renewal noticeBuilt 1997 · S/N 340B413N417XJBank Of Utah Trustee · Salt Lake City, UTS/N 340B417N419CLLegends Cargo Aircraft LLC · Lakeland, FLBuilt 1997 · S/N 340B-419N422BNAntares Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 20735N427PEAcc Integrated Services Inc · Milwaukee, WIBuilt 1984 · S/N SH3692N431BCJahn431bc LLC · Miami, FLBuilt 1991 · S/N 340B-260N432CLLegends Cargo Aircraft LLC · Lakeland, FLBuilt 1997 · S/N 340B-432N438AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49456N438BNAntares Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 21045N440CLBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 340B-440N441FFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1998 · S/N 340B441N44503Frontera Flight Holdings Inc · Dover, DEBuilt 1989 · S/N 49797N458CLBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 340B-458N471EVGugu Ltd · Bellevue, WAS/N 20651N472EVFletcher Aviation Services LLC · Bismarck, NDBuilt 1971 · S/N 20320N481BCJahn481bc LLC · Miami, FLBuilt 1991 · S/N 340B-274N482AAArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49675N483AArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49676N492AKWin Win Aviation Inc · Wake Forest, NCS/N SH3415N502DADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 21304N53993United States Government · Fort Belvoir, VAFirst renewal noticeBuilt 1985 · S/N 104N553AAFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53083N556AAFrontera Flight Holding Inc · Dover, DEBuilt 1991 · S/N 53086
Back to AD 91-10-01