Registered aircraft · 130

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:79-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-18-13') 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:79-18-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-18-13')
  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:79-18-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-18-13')
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.

N5BGLinscott Jeffrey Rodman · Boring, ORBuilt 1988 · S/N S799 N6032ESummit Helicopters Inc · Salem, VABuilt 1996 · S/N 5232 N62409Costa James J · Goff, KSBuilt 1962 · S/N 1455 N6651HR & R Conner Aviation LLC · Conner, MTBuilt 1979 · S/N 45211 N66RRRiggs Rock Alan · Lake Mary, FLBuilt 1979 · S/N 45278 N69FHelicopters Inc · Cahokia, ILBuilt 1996 · S/N 53025 N705FSHvl Construction Inc · Fresno, CABuilt 1994 · S/N E-2836 N720BGentem Inc Trustee · Wilmington, DEBuilt 1980 · S/N 45452 N721KHBruce Mike · Evadale, TXFirst renewal noticeBuilt 1984 · S/N E-2214 N727JSTrickett Michael W · Washington, DCBuilt 2002 · S/N 5048 N749FFHunt-Lo Farms LLC · Chesterland, OHBuilt 1983 · S/N 45773 N76DCAdvanced Trucking LLC · Kalispell, MTBuilt 1980 · S/N 45471 N771KESchilling Michael K · Kenai, AKBuilt 2004 · S/N 51002C N772DWCcf Ventures Inc · Bangor, MEBuilt 1976 · S/N 007 N775DWCosta James J · Prineville, ORBuilt 1976 · S/N 028 N777EMAlaskan Wings LLC · Anchorage, AKBuilt 1983 · S/N 45767 N77DCOmega 377 Pennsylvania LLC · Shavertown, PABuilt 1985 · S/N E-2289 N7860SMagnum Aviation LLC · Goff, KSS/N 6627 N787RCRegistered aircraftBuilt 1987 · S/N 2012 N8118YSanborn Richard E Trustee · Bethlehem, NHS/N 2017 N888SWSeawind Mjw LLC · Wappingers Falls, NYBuilt 2005 · S/N 60 N902EHNorth Wind Aviation LLC · Chelan, WAS/N 45769 N91018Two Wise Guys Aviation LLC · Le Sueur, MNBuilt 1965 · S/N 3558 N965RWWilmarth Russell · Alton Bay, NHBuilt 2002 · S/N 5047 N96AEAir Evac Ems Inc · O Fallon, MOBuilt 1982 · S/N 45751 N970YGCbk LLC · Eagle, COBuilt 1979 · S/N P21000219 N9762CFort Wolters Helicopters · Mineral Wells, TXBuilt 1962 · S/N 2159 N979NFresh Air LLC · Camarillo, CABuilt 1983 · S/N 45777 N981RDSunrise Adventures LLC · Stillwater, MNBuilt 1981 · S/N U20605872 N9993CTemplar Helicopters LLC · Glendale, AZS/N 45682

Back to AD 79-18-13