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.

N19FSCole Properties LLC · Foley, ALBuilt 1983 · S/N TJ-441N200ERRivera Enrique · Longboat Key, FLS/N P394N2025PBas Part Sales LLC · Greeley, COS/N P-476N2031ZJames Jeb S Dr · Bay City, TXBuilt 1978 · S/N TJ-165N2044ABrowder Daniel Klemp · Shady Valley, TNBuilt 1979 · S/N TJ-190N2056NN2056n LLC · Wilmington, DEBuilt 1978 · S/N TJ-156N20602Bromschwig Kurt F Trustee · Montgomery, TXS/N TJ-173N2061KMile High Air Inc · Canyon, TXBuilt 1978 · S/N TJ-161N2073LBravo Wings II LLC · Grants, NMBuilt 1976 · S/N TJ-73N20CGHyco Industrial Ltd · Houston, TXBuilt 1979 · S/N P-495N20XLTwin Bat Plane LLC · Tupelo, MSS/N P-566N210MKKhosravi Muhsin · Kansas City, KSS/N P-369N2110AWindshear Aviation LLC · Longmont, COBuilt 1977 · S/N TJ-129N214CKBreland Michael · Olympia, WABuilt 1976 · S/N P399N21FHWalker Kevin D · Tres Pinos, CABuilt 1975 · S/N P-356N222GSLandau Management Services Inc · Topanga, CABuilt 1981 · S/N TJ384N222NMBlue Sky Air LLC · Norcross, GABuilt 1977 · S/N P-442N223SBAdams Derek · Lexington, MABuilt 1981 · S/N TJ-339N2271LBurchinal Skyler · Brookston, TXS/N TJ-71N2288LCherryhill Aviation Inc · Freetown, INS/N TJ-70N22AJBranche Gregory A · Ithaca, NYBuilt 1977 · S/N P-441N22BKAday B Joe · Las Cruces, NMBuilt 1974 · S/N P-312N22CCLegacy Air LLC · Oklahoma City, OKBuilt 1984 · S/N TJ-471N22KJb Earthmoving Equipment LLC · Lemont Furnace, PAS/N P-51N22VXDo Good Things LLC · Port Orange, FLBuilt 1978 · S/N TJ-171N230BBBishay Motors & Leasing Inc · Norwood, MAS/N P-460N231WEJones Jason Bart · Frankfort, ILBuilt 1980 · S/N TJ-263N23553Uandmycar.Com Inc · Plattsburgh, NYBuilt 1977 · S/N P-453N23588Bunn Enterprises Inc · Fleming, OHBuilt 1978 · S/N P-454N235DRegistration Pending · Mead, CORegistration pendingBuilt 1978 · S/N TJ-134N237DCHinkle Airspray Inc · Cavalier, NDBuilt 1978 · S/N TJ-133N23PLNewsome Jeff · Blackwell, OKBuilt 1970 · S/N P-128N240HCBlodgett James R · Walnut Creek, CABuilt 1979 · S/N TJ-221N24182Robert Yost Enterprises Inc DBA · Saint Francis, KSBuilt 1978 · S/N TJ-136N242MFTruair LLC · Chaska, MNBuilt 1978 · S/N P-465N249CRA&W Air LLC · Aiken, SCBuilt 1979 · S/N TJ-249N24DHJohnson Dean Scott · Chanhassen, MNBuilt 1979 · S/N P-515N250MMMone Forwarding Lc · Laredo, TXBuilt 1980 · S/N TJ-261N25DAAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1978 · S/N P-483N25RMSky Travel LLC · Clayton, MOS/N TJ-459N260ARDeep South Flying Services LLC · Albany, GABuilt 1983 · S/N TJ436N265DDebalco Enterprises Inc DBA · Colorado Springs, COBuilt 1980 · S/N P-548N268RCGraor Robert A · Las Cruces, NMBuilt 1977 · S/N P-416N269KTJfa Aviation Group LLC · Pompano Beach, FLBuilt 1980 · S/N TJ-324N26HAEpsilon Equity Partners LLC · Houston, TXS/N TJ-486N2770ASealane LLC · Burlingame, CABuilt 1979 · S/N P-492N287KMO'Connor Thomas F · Plano, TXBuilt 1980 · S/N TJ-330N2883WAustin Richard K · Ludington, MIBuilt 1973 · S/N P-238N2889WAviation Institute Of Maintenance · Virginia Beach, VABuilt 1973 · S/N P-249N28WVOrth Duane C · San Antonio, TXBuilt 1978 · S/N TJ124
Back to AD 2002-10-13