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.

N633CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11459N633DAAviation Systems And Service LLC · Mounds, OKBuilt 1974 · S/N 17702214N633MTMajor Air LLC · Charleston, SCBuilt 1976 · S/N 17267904N633NDAyah Investments LLC · Kent, WABuilt 2013 · S/N 172S11292N633WGWings Of Grace Ministries Inc · Melbourne, FLBuilt 1968 · S/N 17256670N63401Evans Harold M · Dunnellon, FLBuilt 1975 · S/N 15077286N63405Christiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10849N63406Searfoss Robert L · Atlanta, GABuilt 1975 · S/N 15077290N63407Mcguire Ryan · Redwood City, CABuilt 1975 · S/N 15077291N6340EAdams Mandy Reed · New Braunfels, TXBuilt 1959 · S/N 46440N6340FCommonwealth Of Massachusetts · Plymouth, MABuilt 1975 · S/N 18264165N63412Knh Aviation LLC · Yuma, AZBuilt 1975 · S/N 15077294N63414Simonis Kenneth W · Girdwood, AKBuilt 1975 · S/N 15077296N63418Knutson Wayne R · Tioga, NDBuilt 1975 · S/N 15077299N63419Aviation Training LLC · Wilmington, DEBuilt 2004 · S/N 17281224N6341APattison Jeffrey L · Glasgow, MTS/N 33141N6341EHansen'S Garage LLC · Spring City, UTS/N 46441N6341FChronister Rex · Fort Smith, ARBuilt 1975 · S/N 18264166N6341GKlapstein David L · Burlington, WIBuilt 1970 · S/N 15071841N6341JAbriam Darryl Mods B · Jacksonville, FLBuilt 1980 · S/N 17273865N6341KRiggin Flight Service Inc · Madison, SDBuilt 1975 · S/N 15077654N6341TGoose Leasing LLC · Ashburn, VABuilt 2008 · S/N 172S10843N63420Compton John · Jennings, LABuilt 1975 · S/N 15077301N63423Hecht Jeffery W · Vassar, MIBuilt 1975 · S/N 15077304N63424Luxaire Center Inc · Deland, FLBuilt 1975 · S/N 15077305N63427Molitor John P · Hatfield, MABuilt 1975 · S/N 15077306N6342BFargo Jet Center LLC · Fargo, NDBuilt 2008 · S/N 172S10842N6342DCourtney Walter William · Cameron Park, CABuilt 1979 · S/N 17272728N6342FNetherton Ricky D · Blair, OKBuilt 1966 · S/N 337-0342N6342XRainier Flight Service LLC · Renton, WABuilt 2008 · S/N 172S10845N6342YFdxp Inc · High Point, NCS/N 21064342N63430Marr Brandon J · Monmouth, ORS/N 18052845N63436Martino Aviation Inc · Rincon, GABuilt 1975 · S/N 15077312N63437Registered aircraftBuilt 1975 · S/N 15077313N6343DAir One Aircraft LLC · Portage Des Sioux, MOBuilt 1979 · S/N 17272729N6343ECatskill Mountain Air LLC · Milford, NYBuilt 1978 · S/N 17272007N6343KRegistration Pending · Fort Lauderdale, FLRegistration pendingBuilt 1975 · S/N 15077655N63445Henderson John K Jr · Westport Island, MEBuilt 1975 · S/N 15077319N63449Popescu Daniel · Nokesville, VABuilt 1975 · S/N 15077323N6344AAvery Timothy · Payette, IDBuilt 1956 · S/N 33144N6344BJerome Buying Station Inc · Jerome, IDS/N 34244N6344ECantley Richard W · Bluff City, TNBuilt 1959 · S/N 46444N6344GVoss Jeffrey A · Plainwell, MIS/N 15071844N6344YCole William G · Garner, NCBuilt 1981 · S/N 21064344N63450Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17275434N63451Sterling James E · Smithville, TXBuilt 1975 · S/N 15077324N63453Fischella Robert R Trustee · Tucson, AZBuilt 1975 · S/N 15077326N63455Airspeed Jet Services LLC · Kirkland, WAS/N 15077328N63456Ace Of Spades Aviation LLC · Las Vegas, NVBuilt 1981 · S/N 17275435N63458Fowler Ron · Lopez Island, WAS/N 18052847
Back to AD 79-10-14 R1