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.

N56HMBarrett Keith Alan · Anniston, ALBuilt 1984 · S/N TJ-466N581CBColorado Baron LLC · Ketchum, IDBuilt 1979 · S/N TJ-233N582SBHardy Gordon H · Belmont, CABuilt 1978 · S/N TJ-172N582TAWiday John P · El Cajon, CABuilt 1979 · S/N TJ-191N584DSRose Michael · Prescott, AZBuilt 1981 · S/N TJ-343N5858PMatherne David M · Houma, LAS/N TJ446N586HPBell Design LLC · Atlanta, GABuilt 1981 · S/N P-586N5888LDavenport Aviation LLC · Rock Hill, SCS/N P-89N589RBDukas Air LLC · Fort Lauderdale, FLBuilt 1977 · S/N TJ-89N58BPN7ss LLC · Nashville, TNBuilt 1978 · S/N TJ-176N58DFB727 LLC · Midland, TXBuilt 1984 · S/N TJ-453N58HDRoberts John E · Naples, FLBuilt 1979 · S/N TJ-230N58HMA Great Bonanza LLC · Manchaca, TXBuilt 1979 · S/N TJ-205N58JGRvr600 Holdings LLC · Mount Dora, FLBuilt 1982 · S/N TJ-416N58LGMorgan Farms LLC · Twin Falls, IDBuilt 1981 · S/N TJ-393N58LPPrichard Lev H · Dallas, TXBuilt 1985 · S/N TJ-481N58MDLicandro Rudolph · Prospect, KYBuilt 1979 · S/N TJ-248N58PHangar Seven LLC · Penn Yan, NYBuilt 1980 · S/N TJ-303N58PADwt Air LLC · Lakeland, FLBuilt 1981 · S/N TJ-348N58PCGrooms David C · Gallatin, TNBuilt 1977 · S/N TJ-101N58PDFoley Jeffrey William · Scappoose, ORBuilt 1976 · S/N TJ-86N58PECenice LLC · Eagle, COBuilt 1982 · S/N TJ-435N58PRQuinlan John H · Claxton, GABuilt 1978 · S/N TJ-149N58PZMiller Paul David · Dallas, TXBuilt 1981 · S/N TJ-360N58RAGibbs Ron · Parker, AZBuilt 1975 · S/N TJ-14N58TBTaylor Scott · Bg Bnd Ntl Pk, TXS/N TJ-113N58TCN58tc LLC · Gibsonton, FLBuilt 1984 · S/N TJ-455N58TDEaston Douglas J · Sandpoint, IDBuilt 1982 · S/N TJ-411N58TEGtk Services LLC · Carbondale, ILBuilt 1980 · S/N TJ-326N58TFFlying Matters LLC · Cedarburg, WIBuilt 1980 · S/N TJ-292N58VBBeckman Donald A · Rostraver Township, PABuilt 1980 · S/N TJ-260N58ZZDestination Marketing Group LLC · Sedona, AZBuilt 1983 · S/N TJ-432N594DSJsb Aviation LLC · Harrison, ARBuilt 1980 · S/N TJ-318N595XXHolladay Logan · Salt Lake City, UTFirst renewal noticeBuilt 1979 · S/N TJ-189N5BPTippettsolutions LLC · Fort Mill, SCBuilt 1980 · S/N TJ-315N5JKLizard Two LLC · Wilmington, DEBuilt 1981 · S/N TJ-295N6008SAustin Aerial Media LLC · Pflugerville, TXBuilt 1975 · S/N P-338N600CPColumbus Paper Company Inc · Columbus, GABuilt 1982 · S/N P-590N600PAHeaven'S Landing Realty Inc · Clayton, GABuilt 1980 · S/N TJ-250N600PGParis Jet Inc · Great Falls, VABuilt 1979 · S/N P-502N6010SR&R Aviation LLC · Wilmington, DES/N P-350N6011SWelch Troy O · Weatherford, TXBuilt 1974 · S/N P-311N6012SWhaley Carl S · Shelby, NCS/N TJ-15N6017SEisma Thomas Eugene · Golden, COBuilt 1975 · S/N TJ-17N6018SJohnson Thomas G · New Port Richey, FLS/N TJ-19N6024KNabarrette Angel · Odessa, TXBuilt 1979 · S/N TJ-187N6024SAdams Erik S · Bozeman, MTBuilt 1975 · S/N TJ-16N6028SHazellief Joe · Okeechobee, FLBuilt 1975 · S/N P-357N60306Ibikunle Christopher S · Grayson, GABuilt 1979 · S/N TJ-195N6032SRenk Brett J · Sun Prairie, WIBuilt 1975 · S/N P-332
Back to AD 2002-10-13