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.

N825SEKalichman Aviation Inc · Kennewick, WAS/N 21083CN830LMKq Aviation LLC · Old Town, FLBuilt 1988 · S/N 11048CN832TBrown Rod · Ponca, NEBuilt 2002 · S/N 23069CN834KBK3 LLC · Sevierville, TNBuilt 2008 · S/N 25109CN84KGGinz Peter M · Guilford, CTS/N 8047CN854JWG&D Holdings LLC · Provo, UTBuilt 1974 · S/N 6037CN85LEThalman Joseph B · Kenosha, WIBuilt 1995 · S/N 23011CN85MANorthcutt Allan C · Broomfield, COFirst renewal noticeS/N 8059CN85WJJordan Thomas J · Healdsburg, CABuilt 2022 · S/N 18110CN86988Triple W Metal Building Construction LLC · Weatherford, TXBuilt 1973 · S/N 2137CN86MDLol Splash LLC · Helena, MTBuilt 1988 · S/N 4050CN87HYDuke Ray J · Texico, NMBuilt 2000 · S/N 25050CN87MRReisdorfer Mark J · La Follette, TNBuilt 1994 · S/N 23010CN882JHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1999 · S/N 23056CN886ZJohn Galt LLC · Fairbanks, AKBuilt 2022 · S/N 4135CN8880ABroadwell Eric · Woodstock, GAS/N 1108CN888RFTao Engineering · Groveland, CAS/N 5043CN88DKPitts Cabot J · Palmer, AKBuilt 1977 · S/N 7088CN88DXNimer David K · Malad City, IDS/N 7075CN88GRLewis Brad D · Eugene, ORBuilt 1985 · S/N 10006CN88JSDoubravsky Mark Edward · Goldendale, WAS/N 6082CN88KFFore Shannon R · Wasilla, AKBuilt 1988 · S/N 7484CN88RVMyers Thomas A · Yamhill, ORBuilt 1984 · S/N 8026CN897DCRed Baron LLC · Middletown, DES/N 20012CN899ZClimb Solutions LLC · Fayetteville, ARS/N 25099CN89CWEagle Air LLC · Wasilla, AKBuilt 1989 · S/N 4087CN89TPStratton Scott M · Bedford, NHBuilt 2000 · S/N 14100CN8YPClear Blue Marketing Inc · Reno, NVBuilt 1973 · S/N 2187CN9009ESmith Colby B · Higden, ARBuilt 1976 · S/N 7061CN900SPMac Air Inc · Farmington, MOBuilt 1976 · S/N 6168CN9019EBelson Joseph Victor · Bellevue, WABuilt 1976 · S/N 7059CN901SPBailey Michael W · Watauga, SDBuilt 1976 · S/N 6180CN9020ECaturia Jeffrey · Layton, UTBuilt 1976 · S/N 6190CN9024EFodor Scott M · Barryton, MIS/N 7062CN9027EShield Raymond C · Russell, PABuilt 1977 · S/N 7074CN9029EBonny Jefferson I · Sunnyside, WAS/N 7071CN9034EHarris Chet A · Anchorage, AKS/N 6191CN9039ERegistered aircraftBuilt 1977 · S/N 6194CN9041EGallagher Joshua Michael · Fromberg, MTBuilt 1977 · S/N 7073CN904PMBranson Matthew R · Granger, INBuilt 1977 · S/N 7090CN9062ERegistered aircraftBuilt 1977 · S/N 6192CN9065ERatliff Stan D · Wasilla, AKBuilt 1977 · S/N 6193CN9066EKilmer Randall W · Bellefonte, PAFirst renewal noticeBuilt 1977 · S/N 7076CN9071EAntique Aircraft And Automobile LLC · Van Alstyne, TXBuilt 1977 · S/N 7068CN9072ECarlos Gary N · Togiak, AKS/N 6195CN9075ETalley Clifford C · Chowchilla, CABuilt 1977 · S/N 6196CN9076HBeachy Jonas D · Whittington, ILBuilt 1989 · S/N 11040CN9088EBrink Kirk H · Greeneville, TNBuilt 1977 · S/N 7092CN9096ESmith Kevin R · Soldotna, AKBuilt 1977 · S/N 7095CN9099EHanson Garrick D · Clayton, NCBuilt 1977 · S/N 7097C
Back to AD 98-15-18 R1