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.

N6227FAlund Timothy · Watervliet, NYBuilt 1975 · S/N 18264132N6227KBuchman Jeffery · Bushnell, FLBuilt 1975 · S/N 15077600N6227RMidwestern Soaring Assoc · Peculiar, MOBuilt 1965 · S/N 15061527N6227YWest Brook Group Inc · Pleasant Hill, IABuilt 1981 · S/N 21064301N62281Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275242N62283Flight School Of Gwinnett Inc · Lawrenceville, GAS/N 17275244N62287Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17275247N6228FLynch Kent · Edwards, ILBuilt 1965 · S/N 337-0228N6228KSunset Leasing Inc · Sarasota, FLBuilt 1980 · S/N 17274175N6228NGreenwich Venture Partners LLC · Greenwich, CTBuilt 2008 · S/N 172S10695N6228RMangham Charles H · Mineral Wells, TXBuilt 1965 · S/N 15061528N6228SYoder Edwin A Jr · Concord, GAS/N 15067028N62296Sale Reported · Signal Hill, CASale reportedS/N 17275249N62299Blanton Robin Anthony · Vero Beach, FLBuilt 1950 · S/N 15638N6229ABrown Jennifer L · Vancouver, WAS/N 33029N6229CClause James W Trustee · La Quinta, CABuilt 1979 · S/N 21063838N6229EBidus Brent E · Sandpoint, IDBuilt 1983 · S/N 18268353N6229FGav Air Capital LLC · Trophy Club, TXBuilt 1975 · S/N 18264133N6229QChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10697N622APCaradine Jimmie · Commerce, TXFirst renewal noticeBuilt 1969 · S/N 15071086N622CMMcgill Charles · Sunriver, ORBuilt 2000 · S/N 172S8467N622DCCarter Aviation LLC · Denver, COBuilt 1977 · S/N 18503465N622DLColorado Aircraft Corp · Watkins, COBuilt 1975 · S/N 17264853N622EHaggerty Russell P · Bethpage, NYBuilt 1971 · S/N 17260059N622EFEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12821N622FEPeninsula Aero Technology Inc · Kenai, AKBuilt 1971 · S/N 18260805N622FHNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282184N622GPTwenty Two Ashford LLC · Brentwood, TNBuilt 1981 · S/N 17274593N622KCAir Burt LLC · Rochester Hills, MIBuilt 2001 · S/N 18281043N6230Cavanaugh Paul R · Plantsville, CTS/N 15071630N6230DUsda Aphis Wildlife Services · Cedar City, UTBuilt 1979 · S/N 17272648N6230EDean Matthew · Pine Grove, CAS/N 46330N6230SMelnyk Oleg · Willoughby Hills, OHBuilt 1967 · S/N 15067030N6231EMiller Edward P · Northfield, MNBuilt 1978 · S/N 17272001N6231FH & F Aviation Inc · Labelle, FLS/N 17273170N6231RSando Mark T · Carson City, NVBuilt 1965 · S/N 15061531N6232APeters Duane A · Anchorage, AKBuilt 1956 · S/N 33032N6232DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272650N6232RBeavers Benjamin K · Omaha, NEBuilt 1965 · S/N 15061532N6232TDavenport Richard B · Danbury, TXBuilt 1964 · S/N 15060932N62332Skylens LLC · Hammond, LABuilt 1981 · S/N 17275251N6233AAgl Aero LLC · Mckinney, TXS/N 33033N6233DGrauert Ritter Trustee · Van Nuys, CAS/N 17272651N6233FBach Haley Rayna · Sedona, AZS/N 18264135N6233S33sierra LLC · Soldotna, AKBuilt 1967 · S/N 15067033N6233ZMission Aviation Fellowship · Nampa, IDBuilt 1981 · S/N U20606195N62348Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275254N6234ALiu Weston B · Brookline, NHBuilt 1956 · S/N 33034N6234RFly Big Sky LLC · Missoula, MTS/N 15061534N6234SCorbin M Stuller · Yoder, INBuilt 1967 · S/N 15067034
Back to AD 79-10-14 R1