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.

N24AUCasa Of Sc LLC · Georgetown, SCBuilt 1974 · S/N AA5-0588N24WFNeeley Charles J · Richmond, KYBuilt 1974 · S/N AA5-0684N251RXPlane Therapy LLC · Hudson, FLBuilt 1978 · S/N AA5A0545N252DZBernardo Mark · Middleton, MABuilt 1978 · S/N AA5B0736N254Russell Dale Christopher · Sierra Vista, AZBuilt 1978 · S/N AA5B0970N25ERAndrews Brian · Miramar Beach, FLBuilt 1978 · S/N AA5B0855N25PTChuttani Kabir · Plymouth, MABuilt 1976 · S/N AA5B-0248N26052Registration Pending · Bloomington, INRegistration pendingBuilt 1977 · S/N AA5A0407N26069Alliance Flyers Inc · Haslet, TXBuilt 1977 · S/N AA5A0412N26071Byrd Blake L · Southlake, TXBuilt 1977 · S/N AA5A0413N26073Rlkw Enterprises LLC · Dawsonville, GABuilt 1977 · S/N AA5A0414N26076Stevens Vincent T Pc · Ogden, UTBuilt 1977 · S/N AA5A0415N26078Rearick Donald K · Clymer, PABuilt 1977 · S/N AA5A0417N26082Hunt Edmond L · Madison, WVBuilt 1977 · S/N AA5A0420N26086Joe Hoerter LLC · Hilton Head Island, SCBuilt 1977 · S/N AA5A0326N26087Enger Kenneth H · Mesa, AZBuilt 1977 · S/N AA5A0421N26094Hall George M · Blooming Grove, TXBuilt 1977 · S/N AA5A0422N26098Chaput Armand J · Austin, TXBuilt 1977 · S/N AA5A0423N26100Carey International Aviation Services LLC · Rockville Centre, NYBuilt 1977 · S/N AA5A0424N26102Price John Richard · Deer Trail, COS/N AA5A0425N26103Williams Richard · Atlanta, GABuilt 1977 · S/N AA5A0426N26104Sumner Gary W · Knoxville, TNBuilt 1977 · S/N AA5A0402N26106Polymer Depot LLC · Delafield, WIBuilt 1977 · S/N AA5A0427N26107Bravo Romeo Aviation LLC · Arlington, TXS/N AA5A0428N26114Flyinisme LLC · Saint Augustine, FLBuilt 1977 · S/N AA5A0433N26115Picnic Table Productions LLC · Gastonia, NCS/N AA5A0434N26116Fasske Wayne · Crossville, TNBuilt 1977 · S/N AA5A0437N26120Houk David A Jr · Norton, OHBuilt 1977 · S/N AA5A0441N26122Smile Givers · Chico, CABuilt 1977 · S/N AA5A0443N26124Chapman Edward J DBA · Jordan, MNBuilt 1977 · S/N AA5A0444N26127Rose David Alan · Port Orange, FLBuilt 1977 · S/N AA5A0446N26130Bokkers Maike L · Mountain View, CABuilt 1977 · S/N AA5A0447N26136Aoki Nidal · Porter, TXBuilt 1977 · S/N AA5A0452N26142Stamper George William III · Quinton, VABuilt 1977 · S/N AA5A0454N26160Wilson William J · Houston, TXBuilt 1977 · S/N AA5A0455N26163Brown Michael D · Elk Grove, CABuilt 1977 · S/N AA5A0456N26165Moldt Richard W · Montrose, CAS/N AA5A0457N26167Mowery Ronnie G · Spencer, OHBuilt 1977 · S/N AA5A0461N26172Flying Tigers Flight School Ltd · Houston, TXBuilt 1977 · S/N AA5A0465N26179Richardson James D II · Bend, ORBuilt 1977 · S/N AA5A0468N261WARuoho John W · Chaska, MNS/N AA5A0467N26206Breakey Phillip · Pickerington, OHBuilt 1977 · S/N AA5A0471N26234Compositec Inc · Manitowoc, WIS/N AA5A0458N26236Mcdonnel Jack Edward Jr · Woodsboro, TXBuilt 1977 · S/N AA5A0475N26237Registration Pending · Spokane, WARegistration pendingBuilt 1977 · S/N AA5A0476N26239Rice Grantland S · Boston, MABuilt 1977 · S/N AA5A0477N26240Gilmer Thomas · Deridder, LABuilt 1977 · S/N AA5A0478N26244Clear Blue Aviation LLC · Melbourne, FLBuilt 1977 · S/N AA5A0480N26247Royer Virgil P · Salem, ORBuilt 1977 · S/N AA5A0482N26248Wening Brandon · Greenwood, INS/N AA5A0483
Back to AD 95-19-15 R1