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.

N9150MSkyler Aviation Inc · San Diego, CABuilt 1970 · S/N U20601550N91510Registration Pending · Eagle River, AKRegistration pendingS/N 18259800N91513Attactix Aviation LLC · Tucson, AZBuilt 1969 · S/N 18259801N91515Bulkley Gregory A · Spokane, WABuilt 1969 · S/N 18259802N9151HFirst Flight Corp · San Diego, CABuilt 1975 · S/N 17265976N9151MMcatee Kevin Patrick Trustee · Ventura, CABuilt 1976 · S/N 18264703N9151UAdvanced Aviation LLC · New Century, KSBuilt 1976 · S/N 15078102N91529Dutchess Community College · Poughkeepsie, NYBuilt 1969 · S/N 18259808N91538Graves Dale E · Waukesha, WIBuilt 1969 · S/N 18259810N9153BMires James · Newnan, GABuilt 1958 · S/N 36753N9153HSambriski Michael Daniel III · Long Beach, NYBuilt 1975 · S/N 17265978N91541Engelen Patrick J · Rosamond, CABuilt 1969 · S/N 18259811N91546Delta Charlie LLC · Meridian, IDBuilt 1969 · S/N 18259812N9154MUpupnaway LLC · Concord, NCBuilt 1976 · S/N 18264705N9154TLethal Aviation LLC · Kalispell, MTS/N 50654N9154YNolan Daniel R · Wilmington, NCBuilt 2001 · S/N 18280971N91552Reese Ken W · Pewaukee, WIBuilt 1969 · S/N 18259813N91553Simpson Josiah J L Trustee · Shelburne, MABuilt 1973 · S/N 17261500N91557Aero Safe Corporation · Mineral Wells, TXBuilt 1969 · S/N 18259817N91558Cole Christopher W · Bothell, WABuilt 1969 · S/N 18259818N9155AMaki Kevin L · Saginaw, MNBuilt 1950 · S/N 19354N9155MMain Line Flying Association Inc · Blue Bell, PABuilt 1976 · S/N 18264706N91564Siudzinski David · Tuolumne, CABuilt 1969 · S/N 18259819N91568Rasmussen Air LLC · Washington, UTBuilt 1969 · S/N 18259821N9156AStokes Jay M · Kingsland, TXBuilt 1949 · S/N 18917N9156BRegistration Pending · Cheyenne, WYRegistration pendingBuilt 1958 · S/N 36756N9156HSolar Flying Club · Grimes, IABuilt 1975 · S/N 17265981N9156MJolliff Richard · Brady, TXBuilt 1976 · S/N 18264707N9156NBurdick Kenneth M · Swansea, MABuilt 1956 · S/N 28648N9156UHangar6 Aviation LLC · Apex, NCBuilt 1976 · S/N 15078107N91574Capps Edward F · Chaparral, NMBuilt 1969 · S/N 18259823N91576Reeves James Matthew · Corpus Christi, TXBuilt 1969 · S/N 18259825N91579Valentine Jimmie Lloyd Sr · Gulfport, MSBuilt 1969 · S/N 18259826N9157A9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12755N9157BMighells Conrad E · Randolph, NYFirst renewal noticeBuilt 1958 · S/N 36757N9157RHolmes Ronald W · Kent, ORBuilt 1975 · S/N 18802135TN9157URoss Stephen D · Greenfield, OHS/N 15078108N91589Whittles John L · Higganum, CTFirst renewal noticeBuilt 1969 · S/N 18259829N9158HParrish Aviation Flight Academy LLC · Southlake, TXBuilt 1975 · S/N 17265982N9158MScott Richard A · Liberty Lake, WABuilt 1970 · S/N U20601558N9158XSutton Randall D · Rexburg, IDBuilt 1961 · S/N 18253558N91592Sawatzky John E · Oakley, CAS/N 18259832N91596West Michigan Flying Club Inc · Norton Shores, MIBuilt 1973 · S/N 17261505N9159HHess Garrett · Fullerton, CAS/N 17265983N9159UHac Plane LLC · Sugar Land, TXBuilt 1976 · S/N 15078110N915AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13546N915CHLegacy Aire LLC · Kennesaw, GABuilt 1977 · S/N 18266153N915CMVaayu Aviation LLC · Newark, CABuilt 1972 · S/N 17261229N915CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8335N915DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12071
Back to AD 79-10-14 R1