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.

N26454Camarda Edward W · Conroe, TXBuilt 1978 · S/N AA5A0598N26456Coleman Edward H · Tulare, CABuilt 1978 · S/N AA5A0600N26465Registered aircraftBuilt 1978 · S/N AA5A0612N26471N26471 LLC · Versailles, KYBuilt 1978 · S/N AA5A0615N26479N24679 LLC · North Royalton, OHBuilt 1978 · S/N AA5A0619N264CMVasquez Arthur D · Ocala, FLBuilt 1978 · S/N AA5A0588N26655Weyhe Joan Monica · Medford, ORBuilt 1978 · S/N AA5A0623N26661Barber William M · Alden, MIBuilt 1978 · S/N AA5A0547N26664Grumman N26664 LLC · Charlotte, NCBuilt 1977 · S/N AA5A-0518N26670Ward John L · Mexia, TXBuilt 1978 · S/N AA5A0628N26675Kilmurry Thomas · Charlotte, NCBuilt 1978 · S/N AA5A0639N26679Kennann Christopher D · Lubbock, TXS/N AA5A0641N26684Stanard Paul J · Moreland Hills, OHBuilt 1978 · S/N AA5A0644N26685Le Pendu Claude E · Fruit Heights, UTBuilt 1978 · S/N AA5A0645N26688Kirker Edmund J · Omaha, NEBuilt 1978 · S/N AA5A0647N26691Stuckenschneider Robert J · Sedona, AZBuilt 1978 · S/N AA5A0648N26693Truszkowski Donald J · Wyandotte, MIBuilt 1978 · S/N AA5A0649N26695Drude Kris A · Dayton, OHBuilt 1978 · S/N AA5A0651N26696Provincetown Pilots Group Inc · Provincetown, MABuilt 1978 · S/N AA5A0652N26708Flying Chester Cheetah LLC · Valdosta, GABuilt 1978 · S/N AA5A0665N26713N26713 LLC · Gainesville, GAS/N AA5A0668N26715Gulfstream Aerospace Corp · Savannah, GABuilt 1978 · S/N AA5A0670N26717Dumpling Girls LLC · Concord, NCBuilt 1978 · S/N AA5A0671N26718Owen James T · Broken Arrow, OKS/N AA5A0673N26722Neutren Glenn · Fort Bragg, CABuilt 1978 · S/N AA5A0675N26723Fulcrum Software Corp · Raleigh, NCBuilt 1978 · S/N AA5A0676N26725Registered aircraftS/N AA5A0678N26728Schmicker Robert A · Edmond, OKBuilt 1978 · S/N AA5A0680N26733Givens Eric J · Frankfort, OHBuilt 1978 · S/N AA5A0605N26737Noser Thomas C · Bowling Green, KYBuilt 1978 · S/N AA5A0683N26738Hardy David G · Gilbert, SCBuilt 1978 · S/N AA5A0684N26743Lian Jay · Gold Beach, ORBuilt 1978 · S/N AA5A0686N26744Flying Tigers Flight School Ltd · Houston, TXBuilt 1978 · S/N AA5A0688N26757Terranova Jay · Lawrenceville, GAS/N AA5A0695N26758Cooley Carolyn A · Bonifay, FLBuilt 1978 · S/N AA5A0696N26760Davis Dana J · Pismo Beach, CABuilt 1978 · S/N AA5A0699N26768Cheetah268 LLC · Kailua Kona, HIBuilt 1978 · S/N AA5A0704N26770Tuan Vo · Falls Church, VABuilt 1978 · S/N AA5A0705N26778N26778 LLC · Santa Monica, CABuilt 1978 · S/N AA5A0714N26780Campbell Joseph · Niceville, FLBuilt 1978 · S/N AA5A0715N26781Landon Easton Jeffrey Allen · Dresden, TNBuilt 1978 · S/N AA5A0716N26784Texas Cheetah LLC · Sugar Land, TXS/N AA5A0717N26788Redwood Aircraft LLC · Santa Rosa, CABuilt 1978 · S/N AA5A0722N26789Preferred Land Solutions LLC · Belden, MSS/N AA5A0723N26792Mayer David J · Ingleside, ILBuilt 1978 · S/N AA5A0725N26793Registered aircraftBuilt 1978 · S/N AA5A0727N26794Seveca Ventures LLC · Arcola, TXBuilt 1978 · S/N AA5A0728N26796Rivers Robert W · Savannah, GABuilt 1978 · S/N AA5A0581N26799Barton Steve K · Canon City, COBuilt 1978 · S/N AA5A0734N267MTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1974 · S/N 0005
Back to AD 95-19-15 R1