AD 2001-08-08

Registered aircraft · 5,765

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

N113VSaravis Darren S · Long Beach, CABuilt 1965 · S/N D-7958N113XClement James G · Cresson, TXBuilt 1966 · S/N D-8112N11421Beach Prairie LLC · Cedar Rapids, IABuilt 2001 · S/N E-3378N114JDVintage Motors Inc · Beattyville, KYBuilt 1973 · S/N D-9420N114PLMaxwell Jeffreyi · Drayden, MDBuilt 1971 · S/N CE-328N114TPGrj LLC · Lexington, SCBuilt 1975 · S/N D-9801N114WRRib Runner LLC · Sioux Falls, SDS/N D-10052N1156TAero 1 LLC · Kalispell, MTBuilt 1975 · S/N D-9761N1157TSalloom Mary M · Gaithersburg, MDBuilt 1975 · S/N E-640N115CA8k Entertainment Inc · Wells, MEBuilt 1981 · S/N D-10371N1165TFlying J Partners Asset Management LLC · Casper, WYBuilt 1975 · S/N D-9754N1169TMorin Daniel P · New Harbor, MEBuilt 1975 · S/N D-9770N116BDTxbd Investments LLC · Addison, TXBuilt 2002 · S/N E-3454N116TWHatfield David A · West Ossipee, NHBuilt 1973 · S/N D-9529N1170TJf Capital Series LLC · Truckee, CABuilt 1975 · S/N D-9777N1178TDavis Aviation Group LLC · Gastonia, NCBuilt 1975 · S/N E-794N1179TQuad Rabbit Inc · Wilmington, DEBuilt 1977 · S/N E-1124N117ECRambana & Ricci Pllc · Tallahassee, FLBuilt 1977 · S/N E-1118N1183ABronson Nw Inc · Redmond, ORBuilt 1969 · S/N D-9006N1184JD&D Chessies LLC · Wilmington, DEBuilt 1980 · S/N E1690N118CMEastport Vacation LLC · Wilmington, DEBuilt 1977 · S/N CE-707N118NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1991 · S/N CE-1612N118TBColtman Peter O · Colleyville, TXBuilt 1981 · S/N E-1891N118VSmith Gregg W · Lake Jackson, TXBuilt 1966 · S/N D-8096N1194AGta Air Inc · Addison, TXBuilt 1969 · S/N E-159N1195TRoberts Robin W · Birmingham, ALBuilt 1974 · S/N E-629N119EWBte Aviation LLC · Wilmington, DEBuilt 1981 · S/N E-1863N119RBDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1966 · S/N D-8231N119TTBurrell Anthony · Stillwater, OKBuilt 1981 · S/N D-10369N11BXMatthew K Cole · Gillespie, ILBuilt 1972 · S/N CE-388N11GMPlatt Tony E · Riverside, CABuilt 1979 · S/N D-10298N11HTJet X Leasing Inc · Johnson, KSBuilt 1967 · S/N D-8534N11JBFlight Risk Ventures LLC · Missoula, MTBuilt 1971 · S/N D-9234N11JQLosey Charles N Jr · Oneida, TNBuilt 1965 · S/N D-7786N11KSFaulkner Dale R · Burnet, TXBuilt 1969 · S/N D-9017N11RTBraly And Braly Pc · Ada, OKBuilt 1967 · S/N D-8420N11VBRobertson Matthew · Nashville, TNBuilt 1969 · S/N D-9031N11VGSage Aviation LLC · Saint Louis, MOBuilt 1976 · S/N D-9891N11VZLowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N E-397N11WPPlacer Aviation LLC · Loomis, CABuilt 1990 · S/N E-2546N11XMWesley F Walker · Rock Hill, SCBuilt 1999 · S/N E-3225N120DBB & I Leasing LLC · Berryville, VABuilt 1978 · S/N E1276N120MPHall William M · Encinitas, CABuilt 1979 · S/N D-10248N1212GNickeson Family LLC · Maquoketa, IABuilt 1988 · S/N E-2418N121AMEastern Stearman Inc Trustee · Leesburg, VAS/N CE-1126N121BEKrdm LLC · Fallon, NVS/N D-7920N121DSongbird Aviation LLC · Larkspur, CABuilt 1984 · S/N CE-1033N121RWArbuckle Air LLC · Kansas City, MOBuilt 1970 · S/N CE-296N121YPNine Five Alpha LLC · Huntsville, ALBuilt 2000 · S/N E-3359N1222MHagarty Matthew · Coralville, IABuilt 1966 · S/N D-8276
Back to AD 2001-08-08