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.

N6543DBatte Randall E · Forest, MSBuilt 1979 · S/N 17272855N6543FJackson Road Flyers · Wayne, MIS/N 15063143N6543TLequire Wayne A · Maryville, TNBuilt 1960 · S/N 17943N6543VChupito Sabrocito LLC · Paso Robles, CABuilt 1980 · S/N 172RG0766N65447Maxxum Financial Group Inc · Destrehan, LABuilt 2004 · S/N 172S9712N6544ESando Jan R · St Louis Park, MNS/N 56044N6544KWaldron Ronald J · Strongsville, OHBuilt 1980 · S/N 17274209N6544XAnderson Joseph · Tillamook, ORBuilt 1960 · S/N 57544N6544YSchwarzenberg Johannes · Helena, MTBuilt 1981 · S/N 21064429N6545365453 LLC · Blaine, MNBuilt 2004 · S/N 172S9717N6545AWunrow Steven M · River Falls, WIS/N 32442N6545DCosta Flying Service Inc · Painted Post, NYBuilt 1979 · S/N 17272856N6545GBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1971 · S/N 15072045N6545HAmerican Patrols Inc · Midland, TXBuilt 1975 · S/N 17265483N6545TWallis Jamee G · Auke Bay, AKBuilt 1960 · S/N 17945N6545XTail Chaser LLC · Wilmington, DEBuilt 1960 · S/N 57545N6546AHayden Susan R · North Pole, AKBuilt 1956 · S/N 32443N6546EMenard Keith L · Bellevue, TXS/N 56046N6546NMitchell Matthew J · Penn Yan, NYBuilt 1978 · S/N 21063102N6546TDungy Garold E · Gower, MOBuilt 1960 · S/N 17946N65471Overland Aviation LLC · Williston, NDBuilt 2004 · S/N 172S9718N65472Registered aircraftBuilt 2004 · S/N 18281451N65477Nistler Joseph C · Helena, MTS/N 18050637N6547CJrp Management LLC · Williams, AZBuilt 1980 · S/N 21063915N6547GLarson Jerry L Jr · Shelby, MTBuilt 1970 · S/N 15072047N6547MLeder John · Marble, NCS/N 18263748N6547NHart Anthony · Promise City, IABuilt 1978 · S/N 21063103N6547SMiller Bradley J · Joliet, MTS/N 15067347N65489Flight Solutions LLC · Columbia, MOBuilt 1982 · S/N 17275762N6548ANebesky William E · Anchorage, AKBuilt 1956 · S/N 32445N6548ESewell William G Jr · Bremen, GABuilt 1978 · S/N 17272036N6548GRoeder Paul A · Waukon, IABuilt 1970 · S/N 15072048N6548SDersch Jonathan D · Mullica Hill, NJBuilt 1967 · S/N 15067348N6548VMaxwell Frank R · Fairbanks, AKBuilt 1980 · S/N 172RG0771N6548XGardner Maureice E · Garden City, KSS/N 57548N65499Pacific Quality Controls Inc · Wrightwood, CABuilt 2004 · S/N 172S9720N6549DBbjs Investments LLC · Waukesha, WIBuilt 1979 · S/N 17272858N6549ENewton Donald H · Lewistown, MTBuilt 1959 · S/N 56049N6549GAviaschin LLC · Frisco, TXBuilt 1970 · S/N 15072049N6549KBurchinal Sam · Brookston, TXS/N 17251306N6549MWhitinger Ryan · Flowery Branch, GABuilt 1975 · S/N 18263749N654ALMoore Howard · Camden, TNBuilt 1977 · S/N 17269033N654ASDwyer Sean · Edmonds, WABuilt 1975 · S/N 18263788N654CSCharlies Angel LLC · New Castle, DEBuilt 2002 · S/N 172S9166N654NDInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N 172S11470N654PAPurdue Aviation LLC · West Lafayette, INBuilt 2018 · S/N 172S12141N654SPJm Air Holdings LLC · Stevensburg, VABuilt 1998 · S/N 172S8060N65501Right Rudder Arizona LLC · Litchfield Park, AZBuilt 2004 · S/N 172S9721N65504Bg Ip LLC · Saratoga, CAS/N 18281452N65507Cora & Associates LLC · Norcross, GABuilt 2004 · S/N 18281454
Back to AD 79-10-14 R1