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.

N6581VSimmons Claude E · Ocracoke, NCBuilt 1980 · S/N 172RG0777N65821Goodley Scott Val · Denton, TXBuilt 1982 · S/N 17275899N6582AN6582a Leasing Service LLC · Wasilla, AKBuilt 1956 · S/N 32479N6582FHemmatyar Nabi Z · Malibu, CAS/N 15063182N6582MHayward W Blair · Brooks, GAS/N 18263764N6582XMclean Bruce R · Napa, CABuilt 1980 · S/N U20605958N6583FButterfield Rory A · Milan, NMS/N 15063183N6583GRusch Steven A · Sequim, WABuilt 1970 · S/N 15072083N6583MParnell Kevin T · Buhl, IDBuilt 1975 · S/N 18263765N65841Just Plane Stuff Inc · Jackson, MSBuilt 2004 · S/N 172S9763N65842Holladay Aviation LLC · Jacksonville, FLBuilt 1983 · S/N 17275906N6584AWildman Air LLC · Mckinney, TXBuilt 1956 · S/N 32481N6584NHartmann Wayne E · Hill City, SDBuilt 1978 · S/N 21063112N65853Morando Donald W · Myrtle Beach, SCBuilt 2004 · S/N 18281490N6585FBrouse Dan T · Magnolia, TXBuilt 1966 · S/N 15063185N6585GPace Glen M · Columbia, MSBuilt 1970 · S/N 15072085N65860Edb Air Inc · Wilsonville, ORBuilt 2004 · S/N 18281491N65862Top Flight Aviation Inc · Corona, CABuilt 2004 · S/N 18281493N65866Planenutz LLC · Deland, FLBuilt 1983 · S/N 17275908N6586EJordan Sidney G · Wasilla, AKBuilt 1980 · S/N 18504057N6586FLunar Aviation LLC · Tahlequah, OKBuilt 1966 · S/N 15063186N6586HOracle Aviation LLC · Omaha, NEBuilt 1975 · S/N 17265498N6586SMiller William H · Live Oak, FLS/N 15067386N65872Channel Islands Aviation Inc · Camarillo, CABuilt 1983 · S/N 17275909N6587ADuncan William K · Collierville, TNBuilt 1956 · S/N 32484N6587EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17272040N6587FJones Aviation Inc · Biggs, CABuilt 1966 · S/N 15063187N6587GGilkes Simon J · Gilbert, AZBuilt 1970 · S/N 15072087N6588GAstro Aviation Inc · Whitney Point, NYBuilt 1970 · S/N 15072088N6588HSwanson David L · Rolling Meadows, ILBuilt 1975 · S/N 17265500N6588XPc Rental LLC · Ely, MNBuilt 1980 · S/N U20605962N65892Amelia Airways LLC · Boynton Beach, FLFirst renewal noticeBuilt 1983 · S/N 17275914N6589FRush Paul E · Highland, KSS/N 15063189N6589MHaller Eugene Z · East Hampton, NYBuilt 1977 · S/N 21061979N6589SAdamson Paul B · Sparks, NVS/N 15067389N658BWKatmai 658bw LLC · Sun Valley, IDBuilt 1980 · S/N 18267669N658CPArizona Air Salvage · Phoenix, AZBuilt 2005 · S/N 18281658N658EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12539N658JMBlackbird Aero LLC · Boca Raton, FLS/N 18268228N658LMLge Flying Club Inc · Marietta, GABuilt 1973 · S/N 17261599N658MACantele Joseph D · Hickory Hills, ILBuilt 2000 · S/N 172S8529N658NVJp Aero Holdings Inc · Carson City, NVBuilt 1981 · S/N 17275439N658PWWheels Up Aviation LLC · Cochran, GABuilt 2008 · S/N 18282098N658SRJung Sue Elaine · Lawton, OKBuilt 1968 · S/N 17700976N658XLMertz George H III · Reading, PABuilt 1997 · S/N 17280096N65903N65903 LLC · Union Gap, WABuilt 2004 · S/N 18281501N65904Electra Aviation LLC · Wilmington, DEBuilt 2004 · S/N 18281502N65909Oldwater Trailers Inc · Wilmington, DEBuilt 1983 · S/N 17275920N6590EHarbor Air LLC · Sitka, AKS/N 18504058N6590FMapes Peter B · Oscoda, MIBuilt 1966 · S/N 15063190
Back to AD 79-10-14 R1