OpenAirDocs.org
AD 76-14-07 R2

Registered aircraft · 930

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:76-14-07-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-14-07-R2')
  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.

N524BLDouble Lazy H LLC · Delta, COBuilt 1964 · S/N 21058477N526MPS Brown Inc · Durant, OKBuilt 1965 · S/N 21058630N534FLeiser Harry W · Rome, PABuilt 1965 · S/N T210-0109N55CGWick James · Canon City, COBuilt 1964 · S/N 21058434N567DBGardner Law Firm Pllc · Shawnee, OKBuilt 1965 · S/N 21058689N56CKThurber Mark C · Manchester, MDBuilt 1962 · S/N 21058112N56DCAero Services Lc · Woods Cross, UTBuilt 1967 · S/N T210-0280N57MTYee Michael P · Missouri City, TXS/N 21058133N5806FJones Flying Association · Wilmington, DEBuilt 1966 · S/N 21058806N5809FDonnelly Robert J · Edwardsburg, MIBuilt 1966 · S/N 21058809N5815FHubbard Scott N · New Brighton, MNBuilt 1966 · S/N 21058815N5821FFlite Five Inc · Kiowa, KSBuilt 1966 · S/N 21058821N5822FGrein David A · Mokena, ILS/N 21058822N5827FBok Hans · North Dartmouth, MABuilt 1966 · S/N 21058827N5828FKissell Ryan · Mount Vernon, OHBuilt 1966 · S/N 21058828N5829FMoa Klinton J · Bellingham, WABuilt 1966 · S/N 21058829N5830FSuchy Karel · Kenosha, WIBuilt 1966 · S/N 21058830N5833FVermillion Fc-1 LLC · Crystal City, TXBuilt 1966 · S/N 21058833N5842FHci Properties LLC · Frankston, TXBuilt 1967 · S/N 21058842N5843FU3 Aviation LLC · Little Rock, ARS/N 21058843N5850F5850f LLC · Monroe Township, NJBuilt 1967 · S/N 21058850N5852FAlvidrez Investments Group Inc · Lakewood, CABuilt 1967 · S/N 21058852N5855FOrmiston Air LLC · Kismet, KSBuilt 1967 · S/N 21058855N5860FThomas Kirk F · Corpus Christi, TXBuilt 1967 · S/N 21058860N5864FSkaw Jack E · New Auburn, WIBuilt 1967 · S/N 21058864N5867FIndigo Of South Fl Inc · Sunrise, FLS/N 21058867N5869FCavanaugh Gerald R · Friendswood, TXBuilt 1967 · S/N 21058869N5872FStearns Edwin B Jr · Chandler, AZBuilt 1967 · S/N 21058872N5873FWehrman George · Covina, CABuilt 1967 · S/N 21058873N5878FVanreeth Philip J Jr · Woodstock, ILBuilt 1967 · S/N 21058878N5887FDe Leon Christopher · Donna, TXBuilt 1967 · S/N 21058887N5902FPeters Kenneth R · Plainfield, ILBuilt 1967 · S/N 21058902N5904FRegistered aircraftBuilt 1967 · S/N 21058904N5907FIsland City Seaplanes Inc · Cordova, AKBuilt 1967 · S/N 21058907N5908FCharger Aviation LLC · Chariton, IABuilt 1967 · S/N 21058908N5909FHendrix Benton · Eckley, COBuilt 1967 · S/N 21058909N5915FJeffries Phillip L · Belington, WVBuilt 1967 · S/N 21058915N5916FTlc Flying Inc · Colfax, WABuilt 1967 · S/N 21058916N5928FKerr Daniel · Bakersfield, CABuilt 1967 · S/N 21058928N5930FCable Strong Aircraft Holdings LLC · Tyler, TXS/N 21058930N5937FDodson International Parts Inc · Rantoul, KSBuilt 1967 · S/N 21058937N5947FGulf Coast Aviation LLC · Terra Ceia, FLBuilt 1967 · S/N 21058947N5948F5c1 Ltd · Boerne, TXBuilt 1967 · S/N 21058948N5949FRead Travis E · Lumberton, TXBuilt 1967 · S/N 21058949N5952FRedmon David M · Biloxi, MSBuilt 1967 · S/N 21058952N5953FKnickerbocker Thomas C · Houston, TXS/N 21058953N5956XCox David F · Tucson, AZS/N 21058956N5969FBowles Walter Rolando Martinez · Naples, FLBuilt 1967 · S/N 21058969N5982FCharles James Brown · Littlefield, TXS/N 21058982N5984FFct Aviation LLC · Portales, NMBuilt 1968 · S/N 21058984
Back to AD 76-14-07 R2