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.

N7959TArrow LLC · Pateros, WABuilt 1960 · S/N 56659N7959UShugart Tiffany C · Canfield, OHBuilt 1964 · S/N 17251959N795FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13176N795THOcean Aviation Inc · Georgetown, DEBuilt 2022 · S/N 172S12795N7960BHolte Martin W · Burnsville, MNS/N 29760N7960THayden James R · West Fargo, NDBuilt 1960 · S/N 56660N7961BGmitter Joseph J · Forest Lake, MNBuilt 1957 · S/N 29761N7961GAlternate Air Inc · Seattle, WABuilt 1971 · S/N 17259661N7961TBoardman Thomas M · Greenwich, NYBuilt 1960 · S/N 56661N7961XCarruth Sam · Ripon, CABuilt 1961 · S/N 17248461N7961ZBoho LLC · Lewes, DEBuilt 1963 · S/N 15060061N7962BHall Jason J · Moses Lake, WABuilt 1957 · S/N 29762N7962ENesta Alex · Winder, GABuilt 1959 · S/N 17762N7962FFlying Colors Airparts Inc · Leesburg, FLBuilt 1966 · S/N 15064062N7962GR House Leasing LLC · Stormville, NYBuilt 1971 · S/N 17259662N7963BPerkins C Trent Blaise · Wonder Lake, ILBuilt 1957 · S/N 29763N7963GAvian Leasing LLC · Bremerton, WABuilt 1971 · S/N 17259663N7963TSawyers Susan J · Tazewell, VABuilt 1960 · S/N 56663N7963UKischnick Brett A · Lapeer, MIBuilt 1964 · S/N 17251963N7963XHairetown LLC · Johnson City, TNBuilt 1961 · S/N 17248463N7964VNorris John R · Anchorage, AKBuilt 1967 · S/N 18051864N7964XEdwards Jerry T · Palo Pinto, TXBuilt 1961 · S/N 17248464N7965ELangton Kathy A · Exeter, CAS/N 17765N7965ZElliott Frank F · Mojave, CABuilt 1963 · S/N 15060065N7966BBrashar Kevin · Anchorage, AKS/N 29766N7966UPatterson Robert E Trustee · Petaluma, CABuilt 1964 · S/N 17251966N7967BScholz Alan A · Rosamond, CABuilt 1957 · S/N 29767N7967GWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259667N7967TMachowicz Mark M · Eastpointe, MIBuilt 1960 · S/N 56667N7967XSchneider David L · Saginaw, MIBuilt 1961 · S/N 17248467N7967ZBreckenridge Steven C · Farmington, ILBuilt 1963 · S/N 15060067N7968BWaltz Patrick T · Delanson, NYBuilt 1957 · S/N 29768N7968FFlyin Cowboys · Manning, NDBuilt 1966 · S/N 15064068N7968TSiegel Donald S · Northampton, MABuilt 1960 · S/N 56668N7969BConnolly Patrick J · Skaneateles, NYBuilt 1957 · S/N 29769N7969GHealsburg Aviation · Healdsburg, CAS/N 17259669N7969JPegasus Air Ventures LLC · Macedon, NYBuilt 1976 · S/N 18264871N7969XBurnham Bros · Winner, SDBuilt 1961 · S/N 17248469N796EPPrince Ellis C · Frierson, LABuilt 1972 · S/N 17260896N796HAJatavallabhula Narasimha Sastry · Longview, TXBuilt 2006 · S/N 18281796N796SPOpensky Airways LLC · Los Angeles, CABuilt 2001 · S/N 172S8720N796THSanders Flight Training Center Inc · Jasper, ALBuilt 2022 · S/N 172S12796N796WTTaildragger LLC · Blackfoot, IDBuilt 1955 · S/N 26813N796WWCrist Aviation Services LLC · Woodland, CABuilt 2000 · S/N 172S8635N7970EMckenna Terence M · Scotts Valley, CABuilt 1959 · S/N 17770N7970FConnor Christopher Donnie · Chicago, ILBuilt 1966 · S/N 15064070N7970GAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259670N7970UChard Robert L · Byron Center, MIBuilt 1964 · S/N 17251970N7971BKimberling David L · Lincoln City, ORBuilt 1957 · S/N 29771N7971FJanes Christopher D · Columbia, KYBuilt 1966 · S/N 15064071
Back to AD 79-10-14 R1