OpenAirDocs.org
AD 95-19-15 R1

Registered aircraft · 1,889

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:95-19-15-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:95-19-15-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.

N926TEAnderson & Associates Inc · Little Rock, ARBuilt 2002 · S/N 10205N9297YHart Linda B · San Antonio, TXBuilt 1977 · S/N AA5B0547N929TEGilling Bert N · Kula, HIBuilt 2002 · S/N 10208N92KSJolly LLC · Dunn Loring, VABuilt 1991 · S/N 10046N930TEPeters James L · Lindon, UTBuilt 2002 · S/N 10209N932TEGilling Bert N · Kula, HIS/N 10211N933TEBcaz Holdings LLC · Wilmington, DEBuilt 2002 · S/N 10212N934TESpiwak Andrew · Canyon Lake, TXBuilt 2002 · S/N 10213N936TELevine Gary H · Davie, FLBuilt 2003 · S/N 10215N937TEPicton Aaron · Redding, CABuilt 2003 · S/N 10216N938TETiger Flyers LLC · Centre Hall, PABuilt 2003 · S/N 10217N939TESherry James Todd · Quinlan, TXBuilt 2003 · S/N 10218N93EREdal Inc · Plantation, FLBuilt 1992 · S/N 10106N93TEOlwell Cheryl · Bulverde, TXBuilt 1977 · S/N AA5B0475N940TESimmerman John Jr · Harrisburg, NCBuilt 2003 · S/N 10219N942TECardinal Enterprise LLC · Jackson, WYBuilt 2003 · S/N 10221N943TEZbikowski Scott · Lino Lakes, MNBuilt 2003 · S/N 10222N945TELebanon Flying Club Inc · Lebanon, TNBuilt 2003 · S/N 10224N946TEStrange Bird LLC · Hackensack, NJBuilt 2003 · S/N 10225N947TESkyway V LLC · Naples, FLBuilt 2003 · S/N 10226N9498LRaber Jonathan L · Baltimore, MDBuilt 1972 · S/N AA5-0238N949TEBarron Wesley Thomas · Port Orange, FLBuilt 2003 · S/N 10228N94CLEasterbrooks Paul · Chesapeake, VABuilt 1978 · S/N AA5B0742N9500LAtlantic Aero Club Inc · Newark, DEBuilt 1972 · S/N AA5-0100N9505LClark Gabrial Scott · Humble, TXBuilt 1972 · S/N AA5-0105N950TECrutchfield Randolph E · Scottsdale, AZBuilt 2003 · S/N 10229N9513LMott Terry W · Hampton, IABuilt 1972 · S/N AA5-0213N9514LBiller Mary Catherine · Columbus, OHBuilt 1973 · S/N AA5-0214N951ANNorth Branch Aviation LLC · Fort Worth, TXBuilt 1974 · S/N AA5-0669N951FUAerospace Trust Management LLC Trustee · Wilmington, DES/N 10054N951MKFeliciano Gordon F Jr · Thornton, COBuilt 1977 · S/N AA5B0613N9523LCnaa LLC · Mooresville, NCBuilt 1974 · S/N AA5-0523N9524LHritz Michael G · Carlisle, PABuilt 1974 · S/N AA5-0524N9526LAnderson Jeffrey · Ann Arbor, MIBuilt 1974 · S/N AA5-0526N9529LMcdaniel Mark O · Martinsville, INBuilt 1974 · S/N AA5-0529N9530LClark Dale H · Discovery Bay, CABuilt 1974 · S/N AA5-0530N9531LBaker Bob E · Carmichael, CABuilt 1974 · S/N AA5-0614N9532LShattuck Charles W · Goshen, CTBuilt 1974 · S/N AA5-0532N9534LPowley Robert L · Mahwah, NJS/N AA5-0534N9536LFarris Thomas B · Henderson, NVBuilt 1974 · S/N AA5-0616N953DYNeiger Steven W · Portland, ORS/N AA5A0012N953TEL A Mesa Ventures LLC · Denison, TXBuilt 2004 · S/N 10232N9543L10 Skies LLC · Rockport, TXBuilt 1974 · S/N AA5-0605N9544LFortnight Aviation LLC · Philadelphia, PAFirst renewal noticeBuilt 1974 · S/N AA5-0543N9545LMoore Walter Robert · Bradentone, FLBuilt 1974 · S/N AA5-0655N9549LAmbrose Martin S · Springfield, MABuilt 1974 · S/N AA5-0549N954TEBabin Michael K Jr · Cresson, TXBuilt 2004 · S/N 10233N9550LSale Reported · Colorado Springs, COSale reportedS/N AA5-0550N9552LHollin Myron · Guilford, INBuilt 1974 · S/N AA5-0674N9554LWilson Tyler · Blooming Prairie, MNBuilt 1974 · S/N AA5-0676
Back to AD 95-19-15 R1