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.

N561TPKerner Christine A · Yelm, WABuilt 1988 · S/N 11041CN56286Rigoni Terry N · Prescott, AZS/N 7221CN56290Franscioni Farms Inc · Salinas, CABuilt 1978 · S/N 7220CN56291Mccall Albert B II · Lebanon, TNS/N 7223CN56294Sprague Roy W · Pie Town, NMBuilt 1978 · S/N 9001CN56298Breffeilh Robert A · Juneau, AKBuilt 1978 · S/N 7227CN5629NDusaint Jonathan E · Bishop, CABuilt 1978 · S/N 7216CN56302Ginther Michael P · Orange Township, NDBuilt 1978 · S/N 7235CN56304Registered aircraftS/N 7236CN5630DRegistered aircraftBuilt 1978 · S/N 7233CN5630NLeve Robert M · Canton, CTBuilt 1978 · S/N 7226CN5630VMccardle Aviation LLC · Kalispell, MTS/N 7242CN56310Kudlacek Ondrej · Lavon, TXBuilt 1979 · S/N 7255CN56315Registered aircraftBuilt 1979 · S/N 7259CN5631RSullivan Shawn R · Morganton, NCS/N 7249CN56328Registration Pending · Camarillo, CARegistration pendingBuilt 1979 · S/N 7270CN5632AHerrin David R · Patterson, GABuilt 1979 · S/N 7256CN5632NCastle Brian B · Craig, AKBuilt 1979 · S/N 7251CN5632RInternational Air Services Inc Trustee · Carson City, NVS/N 7244CN56332Smith Paul G · Wasilla, AKBuilt 1979 · S/N 7253CN56335Maule Air Inc · Moultrie, GABuilt 1979 · S/N 7265CN5633BGood Airplanes LLC · Oshkosh, WIBuilt 1979 · S/N 7271CN5633HDunne Terence J · Wasilla, AKBuilt 1979 · S/N 7268CN5633LCavenagh Thomas D · Lawton, OKBuilt 1979 · S/N 7261CN5633UStaples Clint B · Glen Rose, TXBuilt 1979 · S/N 8003CN5633ZMulder Gene D · North Sioux City, SDBuilt 1979 · S/N 7266CN56347Smith Dale · Windsor, CABuilt 1979 · S/N 7277CN5634SSmb Air Inc · Crescent Springs, KYBuilt 1979 · S/N 8004CN5634YPottenger Charles R · Lewiston, IDBuilt 1979 · S/N 7290CN5635DZuber Gary D · Culver, ORBuilt 1979 · S/N 8006CN5635MGlenn Brian J · Boise, IDS/N 7279CN5635NMann David · Glenn, CABuilt 1979 · S/N 7280CN56366Kerby Ryan S · Talkeetna, AKBuilt 1980 · S/N 7308CN5636DSorensen R L · Soda Springs, IDBuilt 1979 · S/N 7305CN5636HRobertson James S · Welsh, LABuilt 1979 · S/N 7301CN5636MThorpe Caleb D · Las Vegas, NVS/N 7310CN5636NSummit Aviation Holdings Of Nwa Inc · Rogers, ARBuilt 1979 · S/N 7289CN56370Grosgebauer Bryan R · Ogden, UTBuilt 1980 · S/N 7311CN56371Guenther Harry D · Grove City, PABuilt 1980 · S/N 7317CN5637DWestbrook Michael Scott · Mansfield, TXBuilt 1980 · S/N 9004CN5637MAmelia Reid Aviation LLC · San Jose, CABuilt 1980 · S/N 8008CN5637ROlsem Aerial Application Services LLC · Westbrook, MNBuilt 1980 · S/N 7312CN5637WBarry Paul J · Mancos, COBuilt 1980 · S/N 7313CN5638L180 Adventures Inc · Elverson, PAS/N 7299CN5638ZMoser James F · Safford, AZBuilt 1979 · S/N 7294CN56391Mccall Albert B II · Lebanon, TNBuilt 1980 · S/N 7331CN56395Pursuit 53 · College Station, TXBuilt 1980 · S/N 7335CN56398Caprock Spraying Inc · Vega, TXBuilt 1980 · S/N 7340CN5639NPilling Joseph G · Monroe, ORBuilt 1980 · S/N 6206CN563CCWinner Michael W · Evergreen, COS/N 7278C
Back to AD 98-15-18 R1