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.

N4519BOne Niner Bravo LLC · Portsmouth, NHBuilt 1979 · S/N AA5B1048N4519CHosler John F · Mooresville, NCBuilt 1979 · S/N AA5B1049N4519EPalocz Spencer F · Weston, MABuilt 1979 · S/N AA5B1051N451CDDull Kevin M · Northlake, TXBuilt 1978 · S/N AA5B0995N45204Markelov Sergey · Naperville, ILBuilt 1979 · S/N AA5B1067N45208Bunker Wayne M · Cape Carteret, NCBuilt 1979 · S/N AA5B1069N4520BOhara William P · Atco, NJBuilt 1979 · S/N AA5B1060N4520LWilliams James A · Newark, DEBuilt 1979 · S/N AA5B1062N4520NHurley Peter · Clearwater, FLBuilt 1979 · S/N AA5B1063N45210Domogala David J · Southbury, CTBuilt 1979 · S/N AA5B1076N45211Beloit Aviators LLC · Jefferson, WIBuilt 1979 · S/N AA5B1077N4521C4 Legged Fliers LLC · Brick, NJBuilt 1979 · S/N AA5B1071N4521LCarey Daniel · Rockville Centre, NYS/N AA5B1072N4521NMehraban Seyed Habib · Los Angeles, CABuilt 1979 · S/N AA5B1073N4521VPirri Anthony N · East Falmouth, MABuilt 1979 · S/N AA5B1075N45223Moran Timothy P · Acworth, GABuilt 1979 · S/N AA5B1088N45226Gildersleeve Robert · Storrs, CTBuilt 1979 · S/N AA5B1089N4522BKlifman Dustin · Muskegon, MIBuilt 1979 · S/N AA5B1081N4522LGaines Charles C · Fernandina, FLBuilt 1979 · S/N AA5B1084N4522NFrieling Judson D · Houston, TXBuilt 1979 · S/N AA5B1085N4522ZCandeletti James · Forked River, NJBuilt 1979 · S/N AA5B1087N4523DFalk Thomas M · Silver Spring, MDBuilt 1979 · S/N AA5B1091N45240Buford Thomas Edwin · Lemoore, CABuilt 1979 · S/N AA5B1112N45249Porus Joseph B · Oakland, NJBuilt 1979 · S/N AA5B1115N4524BBarbero Matias J · Cape Coral, FLBuilt 1979 · S/N AA5B1098N4524EHarper Michael B · Buena Vista, COBuilt 1979 · S/N AA5B1099N4524KMorris David R · Montara, CABuilt 1979 · S/N AA5B1100N4524MRohweder Alfredo · Pompano Beach, FLS/N AA5B1102N4524NHorejsi Michael E · Castro Valley, CABuilt 1979 · S/N AA5B1103N4524PRegistered aircraftBuilt 1979 · S/N AA5B1105N4524QRegistered aircraftBuilt 1979 · S/N AA5B1106N4524WRichardson Shane D · Pekin, ILBuilt 1979 · S/N AA5B1109N4524ZMercer Eric S · Ukiah, CABuilt 1979 · S/N AA5B1111N45253Dewey Alice · West Palm Beach, FLBuilt 1979 · S/N AA5B1126N4525BCmis N4525b LLC · Carlsbad, CABuilt 1979 · S/N AA5B1116N4525CBeauchard Lucine E · Morehead City, NCBuilt 1979 · S/N AA5B1117N4525FStallknecht William A · San Antonio, TXBuilt 1979 · S/N AA5B1118N4525L525 Lima Corp · Grayslake, ILBuilt 1979 · S/N AA5B1119N4525NClavey Sean P · Port Orange, FLBuilt 1979 · S/N AA5B1120N4525UBenedict Co LLC · Maryville, TNBuilt 1979 · S/N AA5B1122N4525WHamilton Kevin Michael · Lake Charles, LABuilt 1979 · S/N AA5B1123N4525YGorham James A · Mandan, NDBuilt 1979 · S/N AA5B1124N4525ZPadilla Jesse · Fremont, CABuilt 1979 · S/N AA5B-1125N4526BMorris Scott W · Livermore, CABuilt 1979 · S/N AA5B1127N4526LHeider Timothy Robert · Portland, ORS/N AA5B1129N4526NButler Milton Forest · Oxford, GABuilt 1979 · S/N AA5B1130N45278Becker Air LLC · Stratford, CTBuilt 1979 · S/N AA5B1138N4527LSchramm Harold · Utica, SDBuilt 1979 · S/N AA5B1133N4527NTobin Dwight B · New York, NYBuilt 1979 · S/N AA5B1134N45286Isley Phillip A · Anchorage, AKBuilt 1979 · S/N AA5B1143
Back to AD 95-19-15 R1