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.

N5662ZEdwards Ryan D · Columbus, GABuilt 1985 · S/N 11018CN5663DTripp Joshua R · Rockwood, MEBuilt 1985 · S/N 8080CN5663NMeranda Andrew J · Morganton, NCBuilt 1986 · S/N 11021CN5663YWeltyk Michael R · Oxford, MIS/N 10031CN56643Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 8086CN56646Fiebelkorn James W · Soldotna, AKS/N 8084CN5664NThree Bees Farms Inc · Keysville, GAS/N 10027CN5664RHanson Curtis J · Peyton, COS/N 10032CN5664TCapozzi Robert A · Greenwood, FLS/N 8081CN5664YFurlong Kelly L · Athens, ALS/N 4033CN5666DHlavnicka Thomas L · Big Sandy, MTS/N 10035CN5667DWilliams Field LLC · Gig Harbor, WABuilt 1986 · S/N 10037CN5667TNegrich Samuel William · Mayfield, NYS/N 10045CN5667YPletan Ronald L · Omaha, NES/N 10042CN56681Binggeli Mark · Wasilla, AKBuilt 1987 · S/N 10048CN5668PHender Heather D · Portland, ORBuilt 1986 · S/N 8090CN5669DMurphey Julian R · Knoxville, TNBuilt 1987 · S/N 11029CN5669NLynn Martin K · Brownsboro, ALBuilt 1987 · S/N 11032CN5669PPueringer Matthew B · Britt, MNBuilt 1987 · S/N 8091CN56703Arthur Gerald J · Riverside, CAS/N 8092CN5670DWare Justin L · Texico, NMBuilt 1987 · S/N 4043CN5670HMatyas Joseph J · Drums, PABuilt 1987 · S/N 8093CN5670TMorick Brett W · Angola, INS/N 7475CN5670WSiete Inc · Wilmington, DES/N 10013CN5671GMontana Wingnuts LLC · Kalispell, MTBuilt 1987 · S/N 7479CN56HBLopez Michael · North Pole, AKBuilt 1972 · S/N 2143CN574HBIngram Grant Leigh · Hurricane, UTBuilt 2021 · S/N 4134CN574KBBrooks Flyers LLC · Willow, AKBuilt 2021 · S/N 22046CN574RBGod'S Country Aviation LLC · Trapper Creek, AKBuilt 2018 · S/N 4133CN57ESJc Flight Inc · Wilmington, DEBuilt 2005 · S/N 14116CN57HSHenderson State University · Arkadelphia, ARBuilt 1998 · S/N 17005CN5839RGiraud Stephen · Box Elder, SDBuilt 1995 · S/N 20042CN586ECKall Joseph F · Bozeman, MTBuilt 1998 · S/N 21053CN593AMSandpiper Aircraft LLC · Wilmington, DEBuilt 2007 · S/N 14125CN595RGGoulet Ronald · Toledo, ORBuilt 1995 · S/N 20038CN595ZEvans Samuel F · Iuka, MSBuilt 2008 · S/N 23105CN5ARCraig William O · Holland, MIBuilt 1978 · S/N 7211CN602VASchmidt Toby · Salt Lake City, UTBuilt 1976 · S/N 6027CN6060FKeller Matthew Charles · Wasilla, AKBuilt 1985 · S/N 4023CN606RMachado Manel · Grass Valley, CABuilt 1977 · S/N 6062CN607KCCr Air LLC · Peyton, COS/N 25081CN609DDKlassen Joshua Lynn · Cisco, TXBuilt 1981 · S/N 7393CN6101M316 Aviation LLC · Sandy, ORS/N 7488CN6106AKeller Leroy Scott II · Kalispell, MTBuilt 1987 · S/N 8094CN6106YJanssen Jerry D · Barnesville, MNBuilt 1987 · S/N 4046CN610ADBanana 85z LLC · Los Angeles, CAS/N 7501CN6110CLueck Taylor W · Wasilla, AKBuilt 1987 · S/N 4049CN6114YFlies Warren E · Mesa, AZBuilt 1988 · S/N 11043CN61160Hat Creek Holding Company LLC · Bellville, TXBuilt 1990 · S/N 10076CN611BYVolad Ventures LLC · Sunnyvale, CAS/N 23021C
Back to AD 98-15-18 R1