AD 2012-19-01

Registered aircraft · 51,501

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

N1079JElmore Danny W · Othello, WAS/N 124N1079LTradewinds Aero Group LLC · Sarasota, FLBuilt 1975 · S/N 672N107ACBad Attitude LLC · Lisbon, OHBuilt 1991 · S/N 650-91N107AFKummer Michael · Floyd'S Knobs, INBuilt 2001 · S/N 17281056N107AKLazzaro Chris C · Solvang, CABuilt 1988 · S/N 4055CN107ALAero Tech Services Inc · Lititz, PABuilt 2023 · S/N 172S12989N107AMYoung Mark · Vancouver, WABuilt 1997 · S/N 1385N107APRegistration Pending · New Braunfels, TXRegistration pendingBuilt 2000 · S/N T20608202N107AWDust Donald E · London, OHFirst renewal noticeBuilt 1978 · S/N 474-79N107BJJanowsky Bruce G · Lakewood, NYBuilt 2003 · S/N 6054N107CKleinfelter Myles S · Lafayette, INBuilt 2003 · S/N 2058N107ELAa-Aero LLC · Lewes, DEBuilt 2024 · S/N 172S13140N107FRjm Aviation Partners Inc · Naples, FLBuilt 1986 · S/N 599N107FHThree Sixteen LLC · Danbury, TXBuilt 1997 · S/N 2745N107GASwink James E · Flint, TXS/N 2079N107GSSharp Roscoe A · Deer Park, WAS/N 8-0077N107HPMiddleton Trevor M · Cushing, OKBuilt 1986 · S/N 230N107JDDhall Sanjay · Canton, MIBuilt 1991 · S/N DM062N107KBWatermelon Berry LLC · Fort Worth, TXBuilt 2013 · S/N LT022N107KPPeterman Keith A · Salinas, CABuilt 1998 · S/N 94-0167N107LJRaven Helicopter Corp · Wilmington, DEBuilt 2010 · S/N 13026N107MCVeratix Ventures LLC · Carlsbad, CABuilt 2013 · S/N 4636609N107MECash LLC · Kersey, COS/N 5604N107PAPacific Fleet Aviation LLC · Rochester, NYS/N 27-7854002N107PFConant Dakotah · Ocala, FLBuilt 1998 · S/N 18280220N107RCHat Creek Construction & Development Inc · Glennville, GABuilt 1981 · S/N 172RG0807N107RHHenderson Robert T Jr · Sunny Isles Beach, FLBuilt 1977 · S/N R18200093N107RNHayes Pat · Pittsboro, NCBuilt 2016 · S/N 15-589N107SKFitzpatrick William M · Cleveland, GABuilt 1973 · S/N 17702004N107SSMichael Randall L · Kokomo, INBuilt 2014 · S/N SPS 1401N107STBennett Edward · Church Hill, MDBuilt 2001 · S/N 260007N107TANelson Sarah J · Anchorage, AKBuilt 1975 · S/N 32-7540099N107TBRohde Bruce · Fife, WABuilt 2010 · S/N 0540N107TLGeier Jeffrey E · Colfax, WABuilt 2003 · S/N T18208216N107TSSmith Terry G · Liberty Twp, OHBuilt 1982 · S/N 172RG0907N107VJdj Endeavours LLC · Downers Grove, ILBuilt 1986 · S/N 601N107WTDld Aviation LLC · Ogden, UTBuilt 2024 · S/N T18209133N107XLGreene Stephen D · Granbury, TXBuilt 2017 · S/N 323N107XRQualitair LLC Owner Trustee · MichelstadtBuilt 1999 · S/N 284N107XXCovington Holdings Inc · Covington, OHBuilt 2007 · S/N 71879N1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020231N10816Van Der Merwe Coenraad · Traverse City, MIBuilt 1968 · S/N 244753N1081JSoto Osvaldo · Myersville, MDBuilt 1973 · S/N 81N1082JWild Bills Aviation Inc · Tustin, CAS/N T20608775N1082XWhitmer Ronald N · Ellsworth, KSBuilt 1975 · S/N 28-7505207N1082ZJohnson Henry D · Buena Park, CABuilt 1976 · S/N AA5B0346N1083EDavis Gregory P · Olathe, KSBuilt 1977 · S/N 307-77N1083LBenson Mark D · San Diego, CABuilt 1996 · S/N 24-3393N1083TBaer Matthew · New York, NYBuilt 1989 · S/N 27-0023N1084UGranelli Nicholas · Sherman, TXBuilt 1995 · S/N 27-0201
Back to AD 2012-19-01