OpenAirDocs.org
AD 91-21-01 R1

Registered aircraft · 5,086

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-21-01-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:91-21-01-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.

N3055FWilkinson Air LLC · Huntington, WVBuilt 1978 · S/N 32R-7987068N3056DApplied Aviation LLC · Grain Valley, MOS/N 32R7987060N3056RHassenpflug Derek G · Cincinnati, OHS/N 1598N305MCShen Air II Inc · Mount Crawford, VABuilt 1973 · S/N 32-7340118N305YWRichard L Richards P A Trustee · Coral Gables, FLBuilt 1977 · S/N 31-7852016N3065BVanator John D · Eaton Rapids, MIBuilt 1978 · S/N 32R-7987043N30662Jandair LLC · Ennis, TXBuilt 2004 · S/N 3255023N3066UAjh Aviation LLC · Monroe, LABuilt 2004 · S/N 3257341N3067QKpw Enterprises Inc · Chula Vista, CABuilt 1977 · S/N 32R-7780279N30689Pung Larry J · Hermitage, TNBuilt 1978 · S/N 32R-7885282N3068THomeyer Joanne · Alexander, ARBuilt 1979 · S/N 32R-7987111N3069TTop Tier Truck And Trailer LLC · Amarillo, TXS/N 32R-7987112N3071YHarrys Flying Circus LLC · Tampa, FLBuilt 2004 · S/N 3255018N3075RPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 32R-7987110N3078MCartwright Michael R II · El Cajon, CABuilt 1978 · S/N 32R-7887002N30834Tribec Group International Inc · Medina, OHBuilt 2004 · S/N 3255019N308BEAlge Aviation Inc · Middletown, DES/N 32R-7780110N3092SDavidson Robert I · Coeur D Alene, IDBuilt 2004 · S/N 3257366N3093FChurchill Air LLC · Jamestown, NYBuilt 2004 · S/N 3246221N30947Silver Palms Aviation LLC · Miami, FLBuilt 2004 · S/N 3257367N3094RDrygala Marcin M · Williamsburg, VABuilt 2005 · S/N 3257388N3094WSeneca Flight LLC · Gosnell, ARBuilt 2005 · S/N 3255038N3098NValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 4636357N3099ELustig Consulting LLC · Mount Pleasant, SCBuilt 2005 · S/N 3257382N3099LJsn Aviation LLC · Ocala, FLBuilt 2005 · S/N 3255032N30CPSkyveris LLC · Simi Valley, CABuilt 1973 · S/N 27-7305022N30DFDae Aviation Enterprises Corp · Gilford, NHBuilt 1974 · S/N 31-7401263N30DRRuble Force One LLC · Wilkinson, INBuilt 1978 · S/N 31-7912006N30SAMsm30sa LLC · Jericho, NYS/N 31-7952142N30SCRegistration Pending · Wauchula, FLRegistration pendingBuilt 1981 · S/N 31-8152098N30TPLe Ciel Bleu LLC · Hudson, WIBuilt 1981 · S/N 31-8152062N310CMAir Positive LLC · Selbyville, DEBuilt 1969 · S/N 310P-0178N310PGMid-South Bulk Services Inc · West Memphis, ARS/N 31-7512051N31122Ross Jeremy · Lufkin, TXBuilt 2005 · S/N 3257394N3117KDegatech Systems Inc · Van Nuys, CABuilt 2005 · S/N 3257398N311KFAlpha Papa LLC · Fort Stockton, TXBuilt 1999 · S/N 4636194N3120ETandberg Kjell · Beverly Hills, FLBuilt 2005 · S/N 3257400N31222Dc Air LLC · Lebanon, MOBuilt 2004 · S/N 3257354N312AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1973 · S/N 31-7305015N312CDMcwhorter Properties Graysville LLC · Anniston, ALBuilt 1980 · S/N 31-8052182N312KKHowser Donald Marvin III · Granbury, TXBuilt 2004 · S/N T20608472N313PKCampbell James D · Palo Alto, CABuilt 1976 · S/N 32R-7780037N313RBGlenn Simmons LLC · Point Lookout, NYBuilt 1978 · S/N 32R-7887157N313RMVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208456N3147DOrr Calvin L · Higginsville, MOBuilt 1968 · S/N 32-40412N314K314-K Associates LLC · Stratford, CTBuilt 1983 · S/N 31-8352025N314MEJfw Ranch Consulting LLC · Albuquerque, NMS/N T20608222N3158LScott Terrence Lee · Oakland, CABuilt 1994 · S/N 27-0189N315ENRhino Air LLC · Wilmington, DEBuilt 1977 · S/N 61P-0451-173N315KTMoonrise Flyers Inc · Port Townsend, WABuilt 2001 · S/N 27-0316
Back to AD 91-21-01 R1