OpenAirDocs.org
AD 84-08-04

Registered aircraft · 481

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

N101KGQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N EA392N101PAKeenan Mark · Chico, CABuilt 1979 · S/N EA-39N102DLP & G Trading Co Inc · Trenton, NJBuilt 1994 · S/N EA-567N1086WThomas R Cave Inc · San Jose, CABuilt 1996 · S/N EA-586N1087SVolitation Ventures LLC · El Macero, CABuilt 1996 · S/N EA-587N1096KSlocum Eugene A · Bozeman, MTBuilt 1996 · S/N EA-590N1099MSavery Creek Holdings LLC · Dixon, WYS/N EA-591N10LJHarris Michael V · Wildwood, MOBuilt 1982 · S/N EA-276N1108WEtemadian Ali · Upland, CABuilt 1998 · S/N EA-611N110MEAce States Southwest LLC · Stanton, TXBuilt 1979 · S/N EA-17N1116ZBear Harbor Aviation LLC · Polson, MTBuilt 1997 · S/N EA-596N1119TBest Transportation Inc · Newark, NJBuilt 1996 · S/N EA-593N111PCWright Aviation LLC · Molalla, ORBuilt 1999 · S/N EA-639N1122BBonanza 1122b LLC · Lake Havasu City, AZBuilt 1979 · S/N EA-2N1122YD&P Beech Aviation LLC · Concord, CABuilt 1982 · S/N EA-333N1130QHedges William S · Algona, IABuilt 1997 · S/N EA-598N1136VN1136v LLC · Sheridan, WYBuilt 1996 · S/N EA-592N113AWMontana 1 LLC · Missoula, MTBuilt 1983 · S/N EA-346N11BCBledsoe Lucile M · Wray, COBuilt 1991 · S/N EA-515N11RLBeech Life LLC · Houston, TXBuilt 1980 · S/N EA120N11RMHaig Amy · Redlands, CABuilt 1993 · S/N EA-553N11UYInternational Air Services Inc Trustee · Carson City, NVS/N EA-218N120WTZulu Time LLC · Park City, UTBuilt 1980 · S/N EA-99N121PEEggers Phillip S · Denton, TXBuilt 1983 · S/N EA-388N123AZN123az LLC · Las Vegas, NVS/N EA-498N125ARJuliet Kilo Air 1 LLC · Paradise Valley, AZBuilt 1980 · S/N EA-169N129ABPhilly Express LLC · Wilmington, DEBuilt 1994 · S/N EA-561N1351RN1351r Inc · Middletown, DEBuilt 1979 · S/N EA-21N136BEHeavy D Airways LLC · Fountain Hills, AZBuilt 1992 · S/N EA-541N136BFEisenhart Dwight · Clinton, ARBuilt 1987 · S/N EA-465N136CMTriple C Inc · Carlsbad, NMS/N EA-437N136DDMason Daniel Racing LLC · Porterville, CABuilt 1981 · S/N EA-212N136TCWeis Samuel K · Madera, CABuilt 1979 · S/N EA-15N140KBMcclendon Dan · Burleson, TXBuilt 1979 · S/N EA 36N143CRNkm LLC · Glasgow, MTBuilt 1993 · S/N EA-550N146TAShamash Micah I · Larkspur, COBuilt 1980 · S/N EA-176N1557DB36tc LLC · Salinas, CAS/N EA-494N1559UDetmer Darren D · Chappell Hill, TXBuilt 1994 · S/N EA-557N1564RKm Unlimited LLC · Fallbrook, CABuilt 1988 · S/N EA-487N158NRoss Adam · Texarkana, TXBuilt 1981 · S/N EA-197N1598TRegistered aircraftBuilt 1981 · S/N EA-263N169GRBlue Skies Above LLC · Spring, TXBuilt 1995 · S/N EA-580N171PFRegistration Pending · Los Osos, CARegistration pendingBuilt 1980 · S/N EA-164N1805DDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N EA-233N1807BCloud Nine Corp · Batesville, INBuilt 1981 · S/N EA-234N1807FTurboflyers Inc · Leesburg, VABuilt 1981 · S/N EA-235N1808QBearspoint LLC · Edmond, OKS/N EA-236N1811DRegistration Pending · Kennedale, TXRegistration pending, canceledBuilt 1981 · S/N EA-237N1814EErda LLC · Wilmington, DEBuilt 1981 · S/N EA-241N1817AKlinefelter Kristopher J · Phoenix, AZBuilt 1981 · S/N EA-243
Back to AD 84-08-04