OpenAirDocs.org
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.

N1174TDynamic Erp Resources Inc · Mansfield, TXBuilt 1975 · S/N TE-1056N1175TCleared For The Option Aviation Services LLC · Kingwood, TXBuilt 1975 · S/N TH-604N117KASouthern Latitude LLC · Alabaster, ALBuilt 1972 · S/N TE-852N117RSJa1 Aviation LLC · Sedan, KSBuilt 1979 · S/N TJ-224N1183Sweet Aviation LLC · Dover, DEBuilt 1980 · S/N TE 1183N118CFChaudoin Stephen G Trustee · Raymond, NHBuilt 1978 · S/N TH-924N118EDSouth America Tactical & Airborne Cousulting Corp · Wilmington, DEBuilt 1974 · S/N TE-1013N1191AMoore John C DBA · San Miguel, CABuilt 1970 · S/N TG-84N1191DFas Holdings LLC · Osage Beach, MOBuilt 1986 · S/N TH-1506N119ACKidd Kevin A · Key West, FLBuilt 1972 · S/N TH-188N119TWCarter Flygare Inc · Sacramento, CABuilt 1974 · S/N TH-533N11ECBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1970 · S/N TH-128N11EVBonita Beech LLC · Bonita Springs, FLBuilt 1976 · S/N TH-748N11YPDanforth Equipment LLC · Leesburg, FLBuilt 1987 · S/N TH-1509N121AFEway William · Jupiter, FLBuilt 1981 · S/N TH-1254N121BLOlson Brian D · Las Vegas, NVBuilt 1982 · S/N TJ-413N121GJ424 Ventures LLC · Saint Petersburg, FLBuilt 1976 · S/N TJ-62N122CTTurner Eye Clinic Inc · Cabot, ARBuilt 1976 · S/N TE-1070N122RMHolland Mark Drew · San Antonio, TXBuilt 1984 · S/N TH-1416N123BCBlue River Baron 58 LLC · Malcolm, NEBuilt 1977 · S/N TK-41N123GBRegistered aircraftBuilt 1979 · S/N TE-1165N123USLow Gary Mike · Southside, ARBuilt 1982 · S/N TH-1335N123WBHighview LLC · Brentwood, TNBuilt 1978 · S/N TH-937N124MDKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1981 · S/N TJ374N124TJAlan Aviation LLC · Los Angeles, CAS/N TH-923N125BEGomez Eliud · Winter Park, FLS/N TH-43N125LLDykstra Darren · Pacific Grove, CABuilt 1982 · S/N TJ-417N125TCYoung Jeremy · Portland, ORBuilt 1975 · S/N TJ-3N126TKLoftis Chris · Fort Worth, TXBuilt 1980 · S/N TK-126N128WSSkyway Air Taxi LLC · Manassas, VABuilt 2001 · S/N TH-1982N12KSWalton Cheryl H · Indianapolis, INBuilt 1974 · S/N TE-1005N131MEDuncan John H Jr · Bend, ORBuilt 1984 · S/N TJ-451N131TWBaron N131tw LLC · Wilmette, ILBuilt 1974 · S/N TE-963N132BMds Flying LLC · Deephaven, MNBuilt 1981 · S/N TE-1189N134MDAa Aviation LLC · Lewes, DES/N TJ-449N1350SLo Pilato Family Flights Inc · Coral Gables, FLBuilt 1976 · S/N TH868N135FBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N TH816N135RWOneal Eric T · Geneva, FLBuilt 1981 · S/N TJ-351N137JPRitec LLC · Sandown, NHBuilt 1982 · S/N TH-1322N138PBSouth Delta Aviation Inc · West Helena, ARBuilt 1980 · S/N TJ-273N138PLCpg Air LLC · Skaneateles, NYBuilt 1986 · S/N TJ-482N138TLHarvest International Ministries Inc · Texarkana, ARBuilt 1981 · S/N TJ-362N13AKTailwinds Inc · Toms River, NJBuilt 1975 · S/N TH-678N13HMN13hm LLC · Punta Gorda, FLBuilt 1970 · S/N TE-813N13PECamm Air · Spencer, IAS/N TJ-50N13TWSouthern Aerial Service LLC · Douglas, GABuilt 1985 · S/N TH-1468N140SGta Air Inc · Addison, TXBuilt 1980 · S/N TH-1155N141PCCleggs Termite And Pest Control · Morehead City, NCS/N TH-2091N142DRHj & L Air LLC · Sacramento, CABuilt 1985 · S/N TH-1458N142SMed Care Inc · Grand Island, NEBuilt 1975 · S/N TH-693
Back to AD 2002-11-07