OpenAirDocs.org
AD 98-15-18 R1

Registered aircraft · 1,210

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:98-15-18-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-15-18-R1')
  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.

N3917CGortemiller Trevor Allen · Atkins, ARBuilt 1971 · S/N 2067-CN391XSullinger Billy · Pocahontas, ARBuilt 1976 · S/N 6183CN394XBenham Aaron J · Sullivan, INS/N 7022CN3952VParker Venable · Malad City, IDBuilt 1987 · S/N 4038CN395XRegistration Pending · Marion, MTRegistration pending, pending cancellationBuilt 1976 · S/N 7037CN397XMikepaparomeo LLC · Bend, ORBuilt 1976 · S/N 7033CN398XHarwood Otway P II · Goochland, VABuilt 1976 · S/N 6185CN399ZFlyin Horse LLC · Columbus, GAS/N 25082CN3MLTherp Todd J · Rigby, IDBuilt 1970 · S/N 2048CN40030Cantrell James E Trustee · Decatur, GABuilt 1998 · S/N 21052CN4020DInnovative Design Group Inc · Watkinsville, GABuilt 1999 · S/N 21063CN4027Wiley Calvin B · Summer Shade, KYS/N 4027CN402XWeyrauch Paul H · Ray, NDBuilt 1976 · S/N 7035CN40303Dalziel Inc · White Salmon, WABuilt 1971 · S/N 3006CN40304Howard Nathan L · Fairbanks, AKBuilt 1971 · S/N 2078CN40309Laurain Terry · Monroe, MIBuilt 1971 · S/N 2085CN40312Banks Mark Vernon · Jamestown, CABuilt 1971 · S/N 2086CN40314Husbands Jason · Belen, NMBuilt 1971 · S/N 2090CN40319Mceewen David L · Galata, MTBuilt 1972 · S/N 2094CN40324Weir John · High Point, NCS/N 2099CN40326Registration Pending · Bowdoin, MERegistration pendingBuilt 1972 · S/N 2101CN40329Goering Ryan I · Prineville, ORS/N 2104CN40330Hubbell Jef C · Kermit, TXBuilt 1972 · S/N 2105CN40331Snow Joe W · Pauls Valley, OKBuilt 1972 · S/N 2106CN40333Cathriner Robert A · Frisco, TXBuilt 1972 · S/N 2108CN40335Davis Philip L · Spring Hill, TNBuilt 1972 · S/N 2110CN40341Beer Carter · Columbus, MTBuilt 1972 · S/N 2117CN40342Rockwell Tracey W · Atlanta, INBuilt 1972 · S/N 2118CN40344Howard Nathan L · Fairbanks, AKBuilt 1972 · S/N 2120CN40348Mattson Paul · San Diego, CABuilt 1972 · S/N 2125CN40352Shriner Justin M · North Pole, AKS/N 2130CN40354Wright Leva M · Somerville, ALBuilt 1972 · S/N 2132CN403XCc Motors LLC · Redding, CABuilt 1976 · S/N 7036CN4055XAtlas Air LLC · Salt Lake City, UTBuilt 1974 · S/N 5055CN405XStover Lance E · Eden Prairie, MNBuilt 1976 · S/N 7038CN40606Huberd Jason K · Hereford, AZS/N 2135CN40614Marcotte Stuart E · Soldotna, AKBuilt 1972 · S/N 2138CN40617Morelli John Anthony · Grapevine, TXS/N 2140CN40619Merrell Jared · Wasilla, AKS/N 2141CN40628Herrington John · Marion, MTBuilt 1972 · S/N 2149CN40629Tejas Flying Services LLC · Ganado, TXBuilt 1972 · S/N 2150CN40633Rice Richard L · Rossville, TNBuilt 1972 · S/N 2151CN40634Nichols Michael H · Thompson Falls, MTBuilt 1972 · S/N 2152CN40635Yuan Andrew W · Salinas, CABuilt 1972 · S/N 2153CN40640Koch Christopher P · Batavia, NYS/N 2158CN40645Ulrich Maggie Beth · Damascus, VABuilt 1972 · S/N 2161CN40646Holtzen Larry E · Jerome, IDBuilt 1972 · S/N 2162CN40647Rozum Richard A · Aguila, AZBuilt 1973 · S/N 2163CN40650Palmer Paul W · Joliet, ILBuilt 1973 · S/N 2166CN40653Registration Pending · Pea Ridge, ARRegistration pendingBuilt 1973 · S/N 2167C
Back to AD 98-15-18 R1