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.

N5596BFlyventure LLC · Fort Wayne, INBuilt 1956 · S/N 33596N5596CPatterson Morgan B · Yuma, AZBuilt 1950 · S/N 19650N5596EBrewer Patricia A · Crossville, TNS/N 17096N5596RRegistration Pending · Crossville, TNRegistration pendingBuilt 1965 · S/N 17253201N5597BBucher Burton W · Waukegan, ILBuilt 1956 · S/N 33597N5597CAom Aircraft LLC · Wilmington, DEBuilt 1950 · S/N 19651N5597ECtj Flyers LLC · Bowdon, GABuilt 1978 · S/N 17271898N5597GRegistration Pending · Washington, UTRegistration pendingBuilt 1969 · S/N 15071097N5597RStevens Daniel T · Trenton, MOBuilt 1965 · S/N 17253202N5598RCross Brian K · Winters, CABuilt 1965 · S/N 17253204N5599CBenien Dennis A · Napoleon, OHBuilt 1950 · S/N 19653N559AKBurton John · Nacogdoches, TXS/N 18258213N559DBRundle James R · Sparks, NVBuilt 1969 · S/N 18260178N559KMRegistered aircraftBuilt 1982 · S/N 18268187N559MCBkjm LLC · Blanchard, OKBuilt 1978 · S/N 18503479N559SP1.2 Gpa LLC · Rapid City, SDBuilt 2000 · S/N 172S8410N559TJHangar 22 LLC · Watkinsville, GABuilt 2000 · S/N 18280852N559TTMcdonald Aviation Mgt LLC · San Jose, CABuilt 1979 · S/N 21063335N55AXWhite Drew C · Granbury, TXBuilt 1964 · S/N 185-0723N55CGWick James · Canon City, COBuilt 1964 · S/N 21058434N55CKDobson Billy M · Tichnor, ARS/N R1722409N55CPCharli Papa LLC · Clovis, NMBuilt 1965 · S/N 18256550N55CSHammond Neil K · Manhattan, KSBuilt 1965 · S/N 337-0222N55DLHill Brock E · Palouse, WABuilt 1955 · S/N 31362N55HAHonaker Group LLC · Sellersburg, INS/N 17269194N55HJRadlinger Joseph · Hudson, WIBuilt 1977 · S/N 18265736N55KAEvans Dick Trustee · Riverside, CAS/N 18052987N55KRBaird Keith W · Marianna, FLBuilt 1975 · S/N 17702344N55LGWard Randy · Port Saint Lucie, FLS/N 17256728N55LHL H Aviation LLC · Clanton, ALBuilt 1955 · S/N 26927N55LULetourneau University · Longview, TXBuilt 2017 · S/N 172S12063N55LWLeeward Aero Sales Corp · Ocala, FLS/N 1851185N55MBSimon Caesar · Carmel, CABuilt 1978 · S/N 18266750N55MPCommanche LLC · Slatington, PAS/N 177RG0668N55MRQc Executive Aviation LLC · Sheridan, WYBuilt 1974 · S/N 18262983N55NABloomhardt Theodore E · Hinesburg, VTBuilt 1974 · S/N 18262915N55NSBrown Nelson S · Auburn, WABuilt 1955 · S/N 31469N55PFBurris Adam Eugene · Graham, WABuilt 1966 · S/N 18257888N55PGGonzalez Pota H · Seguin, TXBuilt 1968 · S/N 17257793N55PLTyriver Katherine R · Orlando, FLBuilt 1958 · S/N 15528N55QBSainthill Raymond C · Long Beach, NYS/N 17269080N55RHMccarthy Michael E · Martinez, CABuilt 1969 · S/N P206-0584N55RXJs Enterprises LLC · Clarinda, IABuilt 1981 · S/N 21064586N55RYTwenty Nine Ninety Two LLC · Edina, MNBuilt 2015 · S/N 18282371N55SNHussey Arthur M III · Fairbanks, AKBuilt 1964 · S/N 18255199N55SVSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2000 · S/N 172S8488N55WBMetro Flyers Ltd · Wilmington, DEBuilt 1975 · S/N 18263900N55YPBmf Jax LLC · Jacksonville, FLS/N F1721930N5600AJessup Modeana M · Wilbur, WABuilt 1956 · S/N 28200N5600BParks Darryl D Trustee · Eagle River, AKBuilt 1956 · S/N 33600
Back to AD 79-10-14 R1