AD 2002-11-07

Registered aircraft · 1,512

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

N1832WTailwinds Aviation LLC · Beechgrove, TNBuilt 1972 · S/N TE-882N18333Rjb Air LLC · Lexington, KYBuilt 1977 · S/N TE-1093N18344Ab Aviation Sales & Rental LLC · Washington, DCBuilt 1978 · S/N TE-1123N18351Iowa Great Lakes Flyers Ltd · Cheyenne, WYBuilt 1977 · S/N TH-855N18358Life Is A Beech LLC · Los Lunas, NMFirst renewal noticeBuilt 1977 · S/N TH-814N18360Anderson Julie A Trustee · Palo Alto, CABuilt 1977 · S/N TE-1106N18361Landvater Darryl V · Williston, VTBuilt 1981 · S/N TH-1290N18363Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N TE-1105N18364Goeken Peter C · Dakota Dunes, SDBuilt 1977 · S/N TH-854N18386Gamco Aviation LLC · Shreveport, LABuilt 1977 · S/N TH-856N18396Drec 0419 LLC · Carson, CAS/N TE-1109N18433J4 Aviation LLC · Lexington Park, MDBuilt 1977 · S/N TK23N1843LRegistered aircraftS/N TJ-65N18475Gerlach And Associates LLC · Valparaiso, INBuilt 1977 · S/N TH-879N1847HQuantum Fly Corp · Boca Raton, FLS/N TK-145N184MBBaker Aviation Consulting LLC · Summerland Key, FLBuilt 1976 · S/N TE-1075N1850FMarcus Air LLC · Plano, TXBuilt 1981 · S/N TE-1195N1852WDavis Sean · Carlisle, IABuilt 1973 · S/N TH-329N1854RSellers William G III · Troy, ALBuilt 1982 · S/N TH-1345N1858PBaron N1858p LLC · Fresno, CABuilt 1981 · S/N TJ-372N185ARortvedt Robert S · Mukwonago, WIBuilt 1973 · S/N TH-332N1865LLiberty Partners Inc · Okmulgee, OKS/N TK-14N186VBLatb LLC · Lewes, DEBuilt 1981 · S/N TH-1239N18748Board Of Trustees Of Southern Illinois Univ · Carbondale, ILS/N TH-875N18752Morgantown Flying Club LLC · Morgantown, WVBuilt 1977 · S/N TH-877N1879LN1879l LLC · Missoula, MTBuilt 1976 · S/N TK-13N1889WSabre 65 LLC · Helena, MTBuilt 1973 · S/N TH-341N188WW3l0 Air LLC · Chuluota, FLBuilt 1976 · S/N TJ-67N1895LPalm Group LLC · Metairie, LABuilt 1977 · S/N TH-894N1896LGolf Lima Aviation LLC · Port Angeles, WABuilt 1976 · S/N TK-16N189CRPelco Investments Inc · Wilmington, DEBuilt 1981 · S/N TE-1187N18HMYoung Craig · Ada, MIBuilt 1975 · S/N TH-651N18SCSpencer Clyde V · Queen Creek, AZBuilt 1977 · S/N TJ-111N18VJAssurance Data Inc · Indiana, PABuilt 1984 · S/N TJ-445N18VRVentura Air LLC · Wilmington, DEBuilt 1996 · S/N TH-1771N1901LBerry Darrel · Camden, TNBuilt 1976 · S/N TH-754N190RSBas Part Sales LLC · Greeley, COBuilt 1977 · S/N TH-804N191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLBuilt 1994 · S/N TH-1720N191WEFs Mickey LLC · East Lansing, MIBuilt 1975 · S/N TE-1059N1973Registered aircraftBuilt 1972 · S/N TE-886N198BArkla Aviation LLC · Farmerville, LABuilt 2000 · S/N TH-1936N199PBSkyflite LLC · Hillsboro, ORS/N TJ-137N19ESRegistered aircraftBuilt 1980 · S/N TJ-296N19FSCole Properties LLC · Foley, ALBuilt 1983 · S/N TJ-441N19KYChi Yang · Lafayette, COS/N TE-1073N19RAAviatzone LLC · Fort Lauderdale, FLS/N TK-44N1BFRussell Kellum LLC · Saratoga, CABuilt 1973 · S/N TE-961N1MFWise Christopher J · Plano, TXS/N TH-835N1MQGc4 Aero LLC · Birmingham, ALBuilt 1976 · S/N TH-731N1PZRegistered aircraftBuilt 1972 · S/N TE-890
Back to AD 2002-11-07