AD 79-10-14 R1

Registered aircraft · 56,582

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:79-10-14-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:79-10-14-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.

N84794Sale Reported · Saint Petersburg, FLSale reportedBuilt 1969 · S/N 17258615N8479GRoscoe J Chandler · Midlothian, TXS/N 15062579N8479LBurton Nathan · Warsaw, MOBuilt 1968 · S/N 17256679N8479MFentress Philip W · Memphis, TNBuilt 1976 · S/N 18264617N8479QLake Airways Management LLC · Hazelhurst, WIBuilt 1976 · S/N U20603337N8479SGreen Meadows LLC · Suphur Springs, TXBuilt 1965 · S/N 18256579N8479TCliff Frederick S · Sunriver, ORBuilt 1959 · S/N 52379N8479XRobinson Jason M · Wilsonville, ORBuilt 1961 · S/N 17248979N847AFRegistration Pending · Boise, IDRegistration pendingBuilt 1957 · S/N 32917N847EAEagle Aviation Columbia LLC · West Columbia, SCBuilt 2004 · S/N 172S9694N847EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12802N847JFKartel Douglas S · Boise, IDFirst renewal noticeBuilt 1977 · S/N 18265690N847JWMoon Samuel C · Bedford, TXBuilt 1976 · S/N 17266700N847KSKansas State University · Salina, KSBuilt 2022 · S/N 172S12834N84801Tolksdorf Alan · California, MDBuilt 1969 · S/N 17258617N84808Johnson Don W · Sage, ARBuilt 1969 · S/N 17258620N84809Dsr-Cherokee 180 LLC · Dallas, TXS/N 17258621N8480GMatthews Scott R · Baker City, ORS/N 15062580N8480JLeach Flight Services LLC · Aledo, TXBuilt 1967 · S/N 15066380N8480LMiss Rebecka LLC · Hancock, MEBuilt 1968 · S/N 17256680N8480MCooper Keith L · Arvada, COBuilt 1976 · S/N 18264618N8480UPeterson Ronald G · Mora, MNFirst renewal noticeBuilt 1964 · S/N 17252380N84811Baumer Jeff A · Stockport, OHBuilt 1969 · S/N 17258622N84815International Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 17258624N84819Jungmeyer And Bruns Aviation LLC · Lees Summit, MOBuilt 1969 · S/N 17258627N8481SQuigley Mark L · Nacogdoches, TXS/N 18256581N8481TWright Eddie · Seneca, SCBuilt 1959 · S/N 52381N8481UThree Rivers Aero LLC · Three Rivers, MIBuilt 1964 · S/N 17252381N8481XN8481x LLC · Canyon, TXBuilt 1961 · S/N 17248981N8481ZMoreau Lloyd J · Penrose, COBuilt 1963 · S/N 205-0481N84823Raw Racing Inc · Puyallup, WABuilt 1969 · S/N 17258630N84827Williams Albert J · Clayton, NCBuilt 1969 · S/N 17258631N8482DJkt LLC · Douglas, WYBuilt 1968 · S/N 185-1370N8482MBuck Carl R · Highland Village, TXFirst renewal noticeBuilt 1976 · S/N 18264620N8482QGregg Flying Service Inc · Durango, COBuilt 1976 · S/N U20603340N8482STwin Cities Aviation Inc · Blaine, MNS/N 18256582N8482TOliver Chad · Groton, SDBuilt 1959 · S/N 52382N84832Raven Canyon Aviation N84832 LLC · Klamath Falls, ORBuilt 1969 · S/N 17258634N84835Boesch Leroy D II · Sebewaing, MIBuilt 1969 · S/N 17258635N84839Lombard David S · Mariposa, CABuilt 1969 · S/N 17258637N8483JHouston County Flying Club · Crockett, TXS/N 15066383N8483LChickasha Wings Inc · Chickasha, OKBuilt 1968 · S/N 17256683N8483SHolman David · Philip, SDBuilt 1965 · S/N 18256583N8483TSiegel Andrew J · Roy, UTS/N 52383N8483UWilson Aviation LLC · Lamar, MOBuilt 1964 · S/N 17252383N8483ZZietz Bode W · Eastland, TXBuilt 1963 · S/N 2050483N84840Worman Russell L · Enumclaw, WABuilt 1969 · S/N 17258638N84849Groen Nicki M · Lynden, WABuilt 1969 · S/N 17258641N8484GAileron Aviation Inc · Cookeville, TNBuilt 1966 · S/N 17255492N8484JBivens Jason D · Duncan, OKBuilt 1967 · S/N 15066384
Back to AD 79-10-14 R1