OpenAirDocs.org
AD 2002-10-13

Registered aircraft · 562

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-10-13')
    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-10-13')
  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.

N6032XWinged Chariot LLC · Cincinnati, OHBuilt 1979 · S/N TJ-197N6044SPinewood Properties LLC · Hayward, WIBuilt 1976 · S/N TJ-42N6047SNeihouser Brad · Francesville, INBuilt 1976 · S/N TJ-37N6048C4g Aerobatics LLC · Saint Petersburg, FLBuilt 1975 · S/N P-348N60500Erda LLC · Wilmington, DES/N P-500N6051SCya Aviation LLC · Estero, FLBuilt 1975 · S/N P-372N6057SRamelow Noyan · Seabrook, TXBuilt 1976 · S/N TJ-45N6059SGallardo Jorge Luis Marquez · El Mirage, AZS/N TJ-49N6060YN6060y LLC · Friendswood, TXBuilt 1981 · S/N P-568N606REPebblebrook Aviation LLC · Ellinwood, KSBuilt 1982 · S/N TJ-430N60AB4 Girls Aircraft LLC · Wilmington, DEBuilt 1977 · S/N P-432N60CLJubjub LLC · Shawnee, KSBuilt 1972 · S/N P-201N60FVMp3 Aviation LLC · Nocona, TXBuilt 1975 · S/N P-333N60NZBlackley Donald W · Cornelius, NCBuilt 1975 · S/N P-339N60PFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N P-87N60RKMajeste Air LLC · Reno, NVBuilt 1969 · S/N P-79N60SHBas Part Sales LLC · Greeley, COBuilt 1980 · S/N TJ-267N6144CLacour Chad · Baton Rouge, LAS/N P-585N615RMMann Robert F · Oshkosh, WIBuilt 1981 · S/N P-584N616GROld Goat Aviation LLC · Chattanooga, TNS/N TJ-184N621WBRicky Bobby USA LLC · Kalispell, MTS/N P393N62254Richard Nestor · Boise, IDS/N TJ-431N626NDay William B · Conroe, TXBuilt 1980 · S/N P-545N62PLTjwg Inc · Grandville, MIBuilt 1980 · S/N TJ-282N6401HBooskye LLC · Dumas, TXBuilt 1981 · S/N TJ-401N6408QAftershock Marketing Inc · Henryville, PABuilt 1982 · S/N TJ-408N640SCBest Crane & Equipment Co LLC · Wilmington, DEBuilt 1979 · S/N P488N6412XFucaimo LLC · South Pasadena, CAS/N TJ-412N64200D&G Baron LLC · Helena, ARBuilt 1982 · S/N TJ-420N649LCSmith Aviation LLC · Sitka, AKBuilt 1980 · S/N TJ-304N64AHFlying Machines LLC · Grand Ledge, MIBuilt 1982 · S/N P-594N64EJLws Flight Service LLC · Lewiston, IDBuilt 1974 · S/N P-288N64RPCoe Administrators LLC · Oshkosh, WIBuilt 1978 · S/N TJ-169N65118Stormy Pilots LLC · Saint Thomas, VIBuilt 1982 · S/N TJ-437N658JSTwo River Airspray LLC · Cavalier, NDBuilt 1977 · S/N TJ100N658MWitherington Properties Inc · Oak Ridge, TNBuilt 1982 · S/N TJ429N65MJPlane Fun Inc Tr Trustee · Snellville, GABuilt 1985 · S/N TJ-487N6641ZVineyard Andrew L · Laguna Hills, CABuilt 1979 · S/N P-509N6643EReynolds Ronnie · White Hall, ARBuilt 1979 · S/N TJ-215N6646ZN1437a LLC · Delray Beach, FLBuilt 1981 · S/N TJ-203N6648KWest Star Lands LLC · Seminole, TXBuilt 1979 · S/N TJ-204N6658ZClark Lloyd E · Hanover, MDBuilt 1979 · S/N TJ-222N6665WIal Corp · Lewes, DEBuilt 1979 · S/N TJ-227N666XGolden Eagle LLC · Estero, FLBuilt 1973 · S/N P-234N6675YField Inspection LLC · Brawley, CABuilt 1980 · S/N TJ-254N6677LAeropacific Consulting LLC · Reno, NVBuilt 1979 · S/N TJ-209N6678C678c LLC · Pensacola Beach, FLBuilt 1979 · S/N TJ-235N6680GHorst Commercial Ventures LLC · Sanger, TXBuilt 1979 · S/N TJ-236N6683NLn Skies LLC · Streetman, TXBuilt 1979 · S/N TJ-239N66HPTwin Lakes LLC · Englewood, COBuilt 1980 · S/N P-530
Back to AD 2002-10-13