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.

N736FYPhydeaux Aviation Ltd · Spartanburg, SCBuilt 1977 · S/N R1722503N736GAPlane Jane Aviation LLC · Sylvania, GABuilt 1977 · S/N R1722505N736GBSilva Monico · Albuquerque, NMBuilt 1977 · S/N R1722506N736GCSilvers Morris · Burnsville, NCS/N R1722507N736GDPactolus Investments LLC · Blounts Creek, NCS/N R1722508N736GGLedocq Melissa A · Green Bay, WIBuilt 1977 · S/N R1722511N736GHTriple R Flying · Monticello, IABuilt 1977 · S/N R1722512N736GJRyan Transfer Inc · Tilden, NEBuilt 1977 · S/N R1722513N736GKOrten Steven S Md · Dallas, TXBuilt 1977 · S/N R1722514N736GNMorrison Scott W · Kokomo, INS/N R1722517N736GUFaria Farms Inc · Tipton, CABuilt 1977 · S/N R1722523N736GVChristiansen Drilling Inc · Ely, NVBuilt 1977 · S/N R1722524N736GWMartin Stephen E · Pampa, TXBuilt 1977 · S/N R1722525N736GZJust US Air LLC · Bradenton, FLBuilt 1977 · S/N R1722528N736HATurner Daniel A · Paragould, ARBuilt 1977 · S/N R1722529N736HBZero-To-1500 LLC · Tacoma, WABuilt 1977 · S/N R1722530N736HDGuthrie John Alex · San Ramon, CABuilt 1977 · S/N R1722532N736HGMcclure Richard A · Victoria, TXBuilt 1977 · S/N R1722535N736HMAir Force Academy Aero Club · Usaf Academy, COBuilt 1977 · S/N R1722540N736HNRegistration Pending · Orange Grove, TXRegistration pendingBuilt 1977 · S/N R1722541N736HSHodgskiss Ben · Choteau, MTBuilt 1977 · S/N R1722545N736HWInvestair LLC · Conway, ARBuilt 1977 · S/N R1722549N736HZBird Chad W · Santa Ana, CABuilt 1977 · S/N R1722552N736JESylvan Air Associates LLC · Lapeer, MIBuilt 1977 · S/N R1722557N736JFHartsuyker David L · Jackson, CABuilt 1977 · S/N R1722558N736JHLloyd Stephen C · Erie, COBuilt 1977 · S/N R1722560N736JKMcfeaters Ryan C · Madisonville, TNBuilt 1977 · S/N R1722562N736JQRaven Limited · Seattle, WABuilt 1977 · S/N R1722567N736JRMckibben Claude · Rochelle, ILBuilt 1977 · S/N R1722568N736JTRose Chris W · Rochester, NYS/N R1722570N736JVRegistered aircraftBuilt 1977 · S/N R1722572N736JWHutcherson David R · Gretna, VABuilt 1977 · S/N R1722573N736JYBorreson Anthony · Mariposa, CABuilt 1977 · S/N R1722575N736KCGreen Robert W · Santa Barbara, CABuilt 1977 · S/N R1722579N736KDAmts LLC · Pleasanton, CABuilt 1977 · S/N R1722580N736KERegistration Pending · Cozad, NERegistration pendingBuilt 1977 · S/N R1722581N736KFEason Richard O · Orono, MEBuilt 1977 · S/N R1722582N736KNTurbine Financial Group LLC · Ogden, UTBuilt 1977 · S/N R1722589N736KPSutton Aircraft Salvage LLC · Palmer, AKS/N R1722590N736KSRigfuel LLC · Eureka, MTS/N R1722593N736KYSicheneder Scott A · Wasilla, AKBuilt 1977 · S/N R1722599N736LBSkyraider Aero Club · Spokane, WABuilt 1972 · S/N 17701825N736LDSteinmeyer Peter A · Arvada, COBuilt 1977 · S/N R1722604N736LGM & R Aviation LLC · Fairview, ORBuilt 1977 · S/N R1722607N736LHDdjrrm Enterprises LLC · Plainfield, INBuilt 1977 · S/N R1722608N736LLSmith Matthew R · Thomaston, GAS/N R1722611N736LMRaducu Radu · Bismarck, NDBuilt 1977 · S/N R1722612N736LPAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1977 · S/N R1722614N736LVEggleston Kenneth W · Bethel, AKBuilt 1977 · S/N R1722620N736LWDrr Boonville LLC · Boonville, NYBuilt 1977 · S/N R1722621
Back to AD 79-10-14 R1