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.

N97GBTaf Aerial Servics LLC · Beeville, TXBuilt 1996 · S/N 14089CN97ZZMx7 LLC · Hudson, OHBuilt 2006 · S/N 22023CN9801MUnderwood Mack C · Aiken, SCBuilt 1966 · S/N 2TN9802MBell Andrew J · Moultrie, GABuilt 1965 · S/N 89N9803MJohnson Craig A · Moreland, GAS/N 88N9804MHastie John L III · Bethel, AKBuilt 1965 · S/N 1037N9808MGerling Matthew Karl · Eagle River, AKS/N 1041N9810MPakuer Levi R · Salmon, IDBuilt 1966 · S/N 1020CN9813MGagnebin Michael · Steamboat Springs, COBuilt 1965 · S/N 1036N9816MShaw David H · Nenana, AKBuilt 1966 · S/N 93N9819MBurnett Scott L · Roswell, NMBuilt 1966 · S/N 1005CN981NWCleerdin Jennifer S · Mack, COS/N 21045CN9823MKoelsch Benjamin · Nome, AKBuilt 1965 · S/N 1007CN9826MBreitbach Perry J · Circle, MTBuilt 1966 · S/N 1010CN982NWInternational Air Services Inc Trustee · Carson City, NVBuilt 1999 · S/N 21046CN9830MChaney George M · Tellico Plains, TNBuilt 1966 · S/N 1015CN9831MPham Hieu T · Steilacoom, WABuilt 1966 · S/N 92N9834MConklin Gregory D · Nevada City, CABuilt 1966 · S/N 1-SN9838MWaldor Asherjohn · Ford City, PAS/N 2CN9839MRegistered aircraftS/N 1027CN9840MBlackstone Christopher M · Oregon City, ORBuilt 1966 · S/N 1022CN9841MMusser Alvin M Jr · Memphis, MOBuilt 1966 · S/N 3CN9845MRichardson Ronald W Trustee · Stewartville, MNBuilt 1966 · S/N 4CN9846MSchrull Robert E · Brattleboro, VTBuilt 1966 · S/N 3SN9849MAndersen Chris · Forest Grove, ORBuilt 1966 · S/N 1032CN9850MCopeland Tyler G · Prineville, ORS/N 5CN9855MNylund Michael K · Wasilla, AKBuilt 1967 · S/N 1034CN9858MUpton James · Guthrie, OKBuilt 1967 · S/N 9CN985DMSanve Karl · Elk City, OKBuilt 1994 · S/N 20009CN9861MSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 1058CN9864MCizek Joseph E · Wasilla, AKS/N 1043CN9865MLaing Thomas L · Aurora, COS/N 2003CN9868MBeckwith Michael E · Kenai, AKS/N 1048CN986RHebblewhite Arthur E · Waunakee, WIBuilt 1971 · S/N 2081CN986WFFehrenbacher Chris · Evansville, INS/N 7208CN9872MBatchelder James · Kenai, AKBuilt 1967 · S/N 1054CN988DDSchumacher Christopher R · Destin, FLBuilt 1989 · S/N 4075CN988MSLong Mark A · Stanton, MIBuilt 1988 · S/N 11058CN989RMMellon Marvin Richard · Naples, FLBuilt 2003 · S/N 18057CN9912DAssociated Property And Business Services LLC · Myrtle Beach, SCS/N 16001CN9918TBertrand Jeff J Trustee · Willow, AKBuilt 1987 · S/N 7491CN995THVold Jon K · Hallock, MNBuilt 1999 · S/N 25044CN997RMBosma Steve J · Outlook, WABuilt 1993 · S/N 4122CN9983PTaf Aerial Services LLC · Beeville, TXS/N 7503CN998JSRegistration Pending · Bend, ORRegistration pending, pending cancellationS/N 18103CN999FTHolt Jacky D Jr · Bogalusa, LABuilt 1978 · S/N 7168CN999MEWindham Jack B · Elba, ALS/N 19042CN999VHMike Charlie Inc · Lewes, DEBuilt 2003 · S/N 25092CN999VVGregory A Pfeil · West Jefferson, OHBuilt 1999 · S/N 25038CN999WPPardue William E · Fort Worth, TXBuilt 2001 · S/N 18051C
Back to AD 98-15-18 R1