OpenAirDocs.org
AD 2016-07-11

Registered aircraft · 44

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

N1254WShar Tam Corp · Faulkton, SDBuilt 1973 · S/N 608N1276WPage Aerial Service Inc · Rochelle, ILBuilt 1975 · S/N 632N1281WJersey Devil Dusters LLC · Southampton, NJBuilt 1975 · S/N 635N1292WJersey Devil Dusters LLC · Southampton, NJBuilt 1975 · S/N 643N197SKBeery Milo A · Clarinda, IAS/N 1645N1999RRas Inc · Danbury, NEBuilt 1997 · S/N 1649N20003Hopkins Robert E Jr · Sumter, SCBuilt 1992 · S/N 1552N2002EBeery Milo A · Clarinda, IABuilt 1992 · S/N 1554N2009WMorris Shepherd · Shorter, ALBuilt 1993 · S/N 1560N20122Gust David R · Harwood, NDBuilt 1994 · S/N 1564N2015NHigh Performance Aviation LLC · Davidson, NCBuilt 1993 · S/N 1567N2021SJersey Devil Dusters LLC · Southampton, NJBuilt 1993 · S/N 1571N20263Ras Inc · Danbury, NEBuilt 1994 · S/N 1575N2032JArnt Aerial Spraying Inc · Worthington, MNBuilt 1994 · S/N 1583N2034MSchindler Rick M · Neligh, NEBuilt 1995 · S/N 1588N2035NPlus Flying Service Inc · Ekalaka, MTBuilt 1995 · S/N 1591N2931WJersey Devil Dusters LLC · Southampton, NJBuilt 1969 · S/N 111N4621ASchindler Rick M · Neligh, NEBuilt 1982 · S/N 1515N4627GDunn Blake C · Bristol, COBuilt 1991 · S/N 1532N4628URons Air Service Inc · Two Buttes, COS/N 1530N4640DRons Air Service Inc · Two Buttes, COS/N 1531N46455Page Aerial Service Inc · Rochelle, ILBuilt 1991 · S/N 1535N4647EFoss And Meier Flight Service · Devils Lake, NDS/N 1537N4656MHofer Perry L · Doland, SDBuilt 1992 · S/N 1540N620RSAeschliman Arlie W · Tribune, KSBuilt 1996 · S/N 1617N620SACropair Flying Service Inc · Cody, WYBuilt 1997 · S/N 1646N65876Kidd Clifford L III · Monahans, TXS/N 1654N9000PCochrane Aaron W · Lake Bronson, MNBuilt 1995 · S/N 1600N90181Air Dakota Flite · Hettinger, NDBuilt 1996 · S/N 1613N90182Tolen Dave · Gallatin, MOS/N 1614N90225Moores Aerial Applicators LLC · Morehead City, NCBuilt 1996 · S/N 1622N90275Double M Farms LLC · Walsh, COBuilt 1996 · S/N 1637N9037WCaraway Darrel P · Red Cloud, NES/N 1018N90393Skyline Aviation LLC · Lewistown, MTBuilt 1995 · S/N 1594N9054WSioux Air Inc · South Sioux City, NEBuilt 1977 · S/N 1022N9057GCb Aerial Application LLC · Queen City, MOBuilt 1997 · S/N 1647N9057TRegistration Pending · Queen City, MORegistration pendingBuilt 1997 · S/N 1648N9058WKirk Ben C · Louisville, MSBuilt 1977 · S/N 1023N9075WDefty Peter A · Visalia, CABuilt 1977 · S/N 1024N9095WDefty Peter A · Visalia, CABuilt 1977 · S/N 1027N9129WJersey Devil Dusters LLC · Southampton, NJS/N 1029N9226WCb Aerial Appliction LLC · Kirksville, MOBuilt 1978 · S/N 1035N9259WRons Air Service Inc · Two Buttes, COS/N 1502N9263WPage Aerial Service · Rochelle, ILS/N 1503
Back to AD 2016-07-11