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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N8476MMoyer Ralph E · Lebanon, PABuilt 1979 · S/N AA5B-1152 N848Wusterhausen William H · Round Rock, TXBuilt 1975 · S/N AA5B-0080 N8488EBroadhead Anne · Corolla, NCBuilt 1979 · S/N AA5B-1240 N84DWBuffalo Valley Aviation LLC · Neosho, MOBuilt 1973 · S/N AA5-0308 N84GSAjluni Robert · Shreveport, LABuilt 1975 · S/N AA5A-0071 N851DFFoster Gregory S · Woodstock, GABuilt 1975 · S/N AA5B-0149 N854PD139th Aeroclub LLC · Miami, FLBuilt 1978 · S/N AA5B-0854 N8588ELongaker Aviation LLC · Salem, VABuilt 1991 · S/N AG5B-10011 N858SFlying Tigers Flight School Ltd · Houston, TXBuilt 1978 · S/N AA5A0636 N85YESouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 10145 N863BWFlying Cheetah LLC · Lakeland, FLBuilt 1978 · S/N AA5A0566 N8656GRut-Roh Flyers LLC · Greer, SCBuilt 1976 · S/N AA5A0247 N865PDGerlach Richard A · Francis, UTBuilt 1977 · S/N AA5B-0407 N86DWWhidbey Flight Services LLC · Coupeville, WABuilt 1973 · S/N AA5-0357 N8755CDebra Cay LLC · Scottsdale, AZBuilt 2003 · S/N 10223 N875LBeaman David · Knoxville, TNBuilt 1977 · S/N AA5B0672 N8764J374dk Aviation LLC · Sand Springs, OKBuilt 1972 · S/N AA5-0116 N877GTSumner Gary · Knoxville, TNBuilt 1976 · S/N AA5A0267 N880DMTiger Aviation Inc · Lake Charles, LAS/N AA5B-0880 N882FDrb Helicopters LLC · Klamath Falls, ORS/N AA5A0783 N8854LPfs Air Inc · Yellville, ARBuilt 1974 · S/N AA5-0654 N8856LRuales Edison R · Miami, FLFirst renewal noticeBuilt 1974 · S/N AA5-0656 N8891LSchendel-Adolf · Elk Grove, CABuilt 1974 · S/N AA5-0695 N8899LSujet Dylan P · Hampton, NJBuilt 1974 · S/N AA5-0698 N889DQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N AA5B-0706 N88NSDaniel Timidaiski · Mukilteo, WABuilt 1975 · S/N AA5B-0196 N895Ghosh Abhimanyu · Mojave, CABuilt 1978 · S/N AA5A0564 N897GAPruim Bradley · Dorr, MIBuilt 1991 · S/N 10076 N898JRKokosa Vernon R · Dennis, MABuilt 1975 · S/N AA5-0706 N89MRKrute Robert D · Staten Island, NYBuilt 1978 · S/N AA5B0730 N89YTYork Travelers Inc · York, PABuilt 1978 · S/N AA5B0739 N9059WGoodnow Connie R · Topeka, KSS/N AA5-0584 N906JBAcosta Marcos E · Yorktown Heights, NYBuilt 1976 · S/N AA5A-0196 N90704Qualitair LLC Trustee · MichelstadtBuilt 1977 · S/N AA-5A0301 N907APWheeler David A · Kennewick, WAS/N AG5B-10001 N911CTMcallen Aviation LLC · Mansfield, LABuilt 1979 · S/N AA5A-0821 N911DKJuneau Christopher · Porter, TXBuilt 1991 · S/N 10015 N915MTMcnutt William E · Ada, MIBuilt 1972 · S/N AA5-0153 N917KDRegistered aircraftBuilt 1976 · S/N AA5A0156 N9186MBlazer Aviation LLC · Charlotte, NCBuilt 1992 · S/N 10122 N9194KHarry Philip · Asheville, NCBuilt 1979 · S/N AA5B-0211 N919LFUnmanned Aerial Research LLC · Freeport, FLBuilt 1978 · S/N AA5B0913 N9208LBrookway Investments LLC · Brookhaven, MSBuilt 1972 · S/N AA5-0218 N920GTBeauchesne Harold J · Enterprise, ALBuilt 1978 · S/N AA5B0920 N920JLBaxley Aviation LLC · Baxley, GABuilt 1972 · S/N AA5-0176 N921DCCarlson Donald A III · Lexington, TNBuilt 1975 · S/N AA5B-0039 N923TEDiscover Resources LLC · Norman, OKBuilt 2001 · S/N 10202 N9242ZProfit Solving Group LLC · Bigfork, MTBuilt 1975 · S/N AA5B-0183 N924TEPlyler Robert S · Spring, TXBuilt 2002 · S/N 10203 N925TEHarris David A · Cleves, OHBuilt 2001 · S/N 10204

Back to AD 95-19-15 R1