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.

N6305SPrivette Hugh T Trustee · Colorado Springs, COS/N 15067105N6305UMission Aviation Fellowship · Nampa, IDS/N U20605411N63062Cade Richard G · Lopez Island, WABuilt 1975 · S/N 15077074N63066Rench Eugene G · Owosso, MIBuilt 1975 · S/N 15077075N6306BGmr Leasing LLC · Lincoln, DES/N 34206N6306CLongs Air Conditioning Inc · Avon Park, FLBuilt 1980 · S/N 21063860N6306FBaymax Aviation LLC · Ronkonkoma, NYS/N 17273186N6306GMartin Robert · Sylvester, GABuilt 1970 · S/N 15071806N63074Charlton Jeremiah · Rockford, ILBuilt 1975 · S/N 15077082N63079Ark Aerospace LLC · Fort Walton Beach, FLBuilt 1975 · S/N 15077087N6307BCarpenter Alan B · Wasilla, AKBuilt 1979 · S/N 18503742N6307JMiloud Chadd · Fort Worth, TXBuilt 1980 · S/N 17273860N6308ABravo Hotel LLC · Lewes, DEFirst renewal noticeBuilt 1956 · S/N 33108N6308BSnyder Kenneth Clayton · Lonsdale, MNBuilt 1959 · S/N 34208N6308GDreher Easton · Wis Dells, WIBuilt 1970 · S/N 15071808N6308HAmerican Aviation Inc · Page, AZBuilt 1978 · S/N 20700476N6308JKatuzienski Joseph C · Yorktown, VABuilt 1980 · S/N 17273861N6308RIngalls Randy · Alexandria, LABuilt 1979 · S/N 172RG0159N63091Hobbs Kole T · Greenville, TXBuilt 1975 · S/N 15077098N63092Lozano Jorge L · Miami, FLS/N 15077099N63095Boyle Daniel K · Llano, TXBuilt 1975 · S/N 15077101N6309BDz Aviation LLC · Nephi, UTBuilt 1957 · S/N 34209N6309GJohnson Robert W · Lebanon, TNS/N 15071809N6309SRegistered aircraftBuilt 1967 · S/N 15067109N6309VHamilton Paul L · Arlington, VABuilt 1980 · S/N 172RG0617N630AMBhh Leasing #3 LLC · Pensacola, FLBuilt 1968 · S/N 337-M0347N630ATAir Tiger LLC · Eunice, LAS/N 18267075N630HRMiga Holdings LLC · Flower Mound, TXBuilt 2006 · S/N 172S10205N630TCN630tc LLC · Nashville, TNBuilt 1976 · S/N 17267047N63101Gill Michael J · Marshfield, MABuilt 1981 · S/N 17275391N6310BWilliams Clayton S · Mason, NHBuilt 1957 · S/N 34210N6310EMinor Mark · Central Point, ORBuilt 1959 · S/N 46410N6310FKierstead Andrew R · Alton Bay, NHS/N 337-0310N6310GAerostar Management Services LLC · Kissimmee, FLS/N 15071810N63113High Road Time LLC · West Palm Beach, FLS/N 17275392N63114Rgw Aviation LLC · Wilmington, DEBuilt 1975 · S/N 15077113N6311FGlasow Eric J · Simpsonville, SCBuilt 1966 · S/N 337-0311N63120Dean James J · Tampa, FLBuilt 1975 · S/N 15077116N63121Aba Contractors Inc · Arcadia, OKBuilt 1975 · S/N 15077117N63122Registered aircraftBuilt 1975 · S/N 15077118N63125Registration Pending · Burnsville, MNRegistration pendingBuilt 1975 · S/N 15077121N63126Aero Marine Inc · Westland, MIBuilt 1975 · S/N 15077122N6312AJosephine Air LLC · Castle Rock, WAS/N 33112N6312BUsda Forest Service Fepp · Helena, MTBuilt 1957 · S/N 34212N6312FCade Steve DBA · Lopez Island, WABuilt 1966 · S/N 337-0312N6312GAshe Robert W · Bethel, CTBuilt 1970 · S/N 15071812N63130Box Talon · Cotulla, TXS/N 18052831N63132Ha Peter · Eastvale, CABuilt 1975 · S/N 15077124N63138Sport Flyer Service LLC · Katy, TXBuilt 1975 · S/N 15077130N6313BLashbrooke Dana F · Durango, COS/N 34213
Back to AD 79-10-14 R1