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.

N100GSPegasus Florida I Inc · San Diego, CABuilt 1974 · S/N P-301N100LSAg Flyers Inc · Torrington, WYBuilt 1969 · S/N P-116N100RABonanza Holdings Group LLC · Greenville, NCBuilt 1977 · S/N P405N101AXFogg Britt · Springdale, ARS/N P427N1024LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N P-78N1042TJbr Leasing Inc · Orlando, FLBuilt 1976 · S/N TJ-79N108LMSkyvista Aviation LLC · Marysville, OHBuilt 1979 · S/N TJ-228N109DWAero East USA LLC · Portage, INBuilt 1976 · S/N TJ13N10GWSereno Re Holdings LLC · Carefree, AZBuilt 1981 · S/N P-570N10NFThompson Benjamin K · Nevada, TXBuilt 1976 · S/N TJ-64N10WPawsitive Rate LLC · Corpus Christi, TXBuilt 1984 · S/N TJ-448N10WEGear Up Inc · Ramona, CABuilt 1977 · S/N P-428N11141Hoitsma Lynn F · Castlewood, SDBuilt 1980 · S/N P-533N111WKMad-Con LLC · Ijamsville, MDBuilt 1977 · S/N P-439N111XLNova Aircraft Inc · Clearwater, FLS/N P-197N112MFMummy Mountain Med LLC · Paradise Valley, AZBuilt 1966 · S/N LP-37N114PJRowe John J · Kansas City, MOBuilt 1982 · S/N TJ-410N1153SThomas Michael R · Saint Clair, MOS/N P-161N1155TCaljet Aviation LLC · Magnolia, TXBuilt 1969 · S/N P-47N117AGRegistered aircraftN-number assigned, not yet registeredS/N LP-20N117RSJa1 Aviation LLC · Sedan, KSBuilt 1979 · S/N TJ-224N120SPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N P-538N121BLOlson Brian D · Las Vegas, NVBuilt 1982 · S/N TJ-413N121GJ424 Ventures LLC · Saint Petersburg, FLBuilt 1976 · S/N TJ-62N1234ASbm Aviation LLC · Afton, WYBuilt 1980 · S/N P-535N1234LRld Leasing Inc · Downers Grove, ILBuilt 1974 · S/N P-320N123JFAlto Aero LLC · Dover, DEBuilt 1974 · S/N P-284N123NKLarson Ken · Escondido, CABuilt 1970 · S/N P-153N124MDKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1981 · S/N TJ374N125LLDykstra Darren · Pacific Grove, CABuilt 1982 · S/N TJ-417N125TCYoung Jeremy · Portland, ORBuilt 1975 · S/N TJ-3N126CAFeltmann Dean A · North Charleston, SCBuilt 1974 · S/N P-257N12EUInternational Air Services Inc Trustee · Carson City, NVS/N P582N12PPAero Verde LLC · Wheat Ridge, COBuilt 1975 · S/N P-334N12SRNorthshore Group LLC · Wilmington, DEBuilt 1974 · S/N P-316N131MEDuncan John H Jr · Bend, ORBuilt 1984 · S/N TJ-451N134MDAa Aviation LLC · Lewes, DES/N TJ-449N135RWOneal Eric T · Geneva, FLBuilt 1981 · S/N TJ-351N138PBSouth 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-362N13PECamm Air · Spencer, IAS/N TJ-50N143DSBen-David Meir · Woodland Hills, CABuilt 1981 · S/N TJ-357N146ZUtah State University · Logan, UTBuilt 1982 · S/N TJ-426N14PGorman Aviation LLC · Bartlesville, OKBuilt 1985 · S/N TJ-492N14VPAmerican Woodcraft LLC · Fort Denaud, FLBuilt 1981 · S/N P-576N151WARoyal Air Charters · Shreveport, LAS/N P-423N152URoyal Air Inc · Shreveport, LABuilt 1968 · S/N P-14N1551LSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N P-391N155ZPennsylvania College Of Technology · Williamsport, PABuilt 1981 · S/N TJ-368
Back to AD 2002-10-13