AD 94-05-05 R1

Registered aircraft · 26,231

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:94-05-05-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:94-05-05-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.

N23508Aviato Research LLC · Phoenix, AZBuilt 1968 · S/N 15068999N2350BWhitmore Joel P · Mesquite, NVBuilt 1948 · S/N 3650N2350NHarris Bradley S · Alexandria, VABuilt 1947 · S/N 12596N2351DPernic David R · Stoughton, WIBuilt 1952 · S/N 20503N2351KYoung Anthony J · Saint Cloud, MNBuilt 1947 · S/N 5078N2352DOptima Aviation LLC DBA · Lewisville, TXBuilt 1952 · S/N 20504N2352VHuddleston Ronnie L · North Vernon, INBuilt 1948 · S/N 14588N2353DJensen Carl V · Raleigh, NCBuilt 1952 · S/N 20505N2353USelman Charles D · Pflugerville, TXS/N 17249953N2353VSpredemann Carl A · Emmett, IDBuilt 1948 · S/N 14727N2355DWest Coast Aerosport Inc · Dove Canyon, CAS/N 20507N2356BHall Noel W · Pinecliffe, COBuilt 1948 · S/N 3656N2356DKirsipuu Paul W · Voluntown, CTBuilt 1952 · S/N 20508N2356UPanko Jeffrey A · Lusby, MDS/N 17249956N2357HFarris Mark E · Richmond, KYBuilt 1946 · S/N 2982N2358URegistration Pending · Cave Creek, AZRegistration pendingBuilt 1962 · S/N 17249958N2358VHerbert Aviation LLC · Spring City, UTBuilt 1948 · S/N 14594N2359VDegolier-Schulze Stephanie L · Jefferson, WIBuilt 1948 · S/N 14595N235NDThunderbird Aviation LLC · Littleton, COBuilt 1998 · S/N C0035N2360HWilson Gary L · Moultrie, GAS/N 2985N2360VZupan Michael J · Mount Vernon, INBuilt 1948 · S/N 14596N2362BGist Jimmy L · Horseshoe Bay, TXBuilt 1948 · S/N 3662N2363DCross John P · Houston, TXBuilt 1952 · S/N 20515N2363VTerpstra Trevor W · Modesto, CABuilt 1948 · S/N 14599N2365BKeller Baxter Benjamin · Madison, CTBuilt 1948 · S/N 3665N2365HCassels William · Phoenix, AZBuilt 1946 · S/N 2990N2365VHolley Jonathan O.A. · Rockmart, GABuilt 1948 · S/N 14601N2366DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 20518N2366KMiller Joey M · San Antonio, TXS/N 5093N2366QBeckcom Gregory N · Hemphill, TXBuilt 1999 · S/N 002N2366VWhite Trevor C · Anchorage, AKBuilt 1948 · S/N 14602N2367BZahler Mitchell J · Stillwater, MNBuilt 1948 · S/N 3667N2367DBushey Abel · Barnet, VTBuilt 1952 · S/N 20519N2367NGeohagan Patrick Tom · Perry, FLBuilt 1947 · S/N 12616N2367VHauser Linda L · Ulysses, KSBuilt 1948 · S/N 14603N2368KBolog Keith · Kenosha, WIS/N 5095N2368UPlehn Thomas R · Las Vegas, NVBuilt 1962 · S/N 17249968N2368VHetchler Glenn A · Erie, COBuilt 1948 · S/N 14604N2369BCc Motors LLC · Redding, CABuilt 1948 · S/N 3669N2369UMahoney Brandon M · Laurelville, OHS/N 17249969N236DAFalany Curtis E · Tallahassee, FLBuilt 1966 · S/N 17254466N236DHMckamey Robert S · Tullahoma, TNBuilt 2003 · S/N DH36N236FBPietrosemoli Castagni Andres · Cary, NCBuilt 1966 · S/N A-158N236MSSylvester Michael L · Trussville, ALBuilt 2016 · S/N 1276N2370DPoeppelman Philip W · Versailles, OHBuilt 1952 · S/N 20522N2370UWatts Keith R · Chapel Hill, TNBuilt 1963 · S/N 17249970N2370VBlackburn Russell A · Clovis, CABuilt 1948 · S/N 14606N2372BKing Larry Joe · Quanah, TXBuilt 1948 · S/N 3672N2372DTucker Matthew T · Dillingham, AKS/N 20524N2372USky View Aviation LLC · Lenoir, NCBuilt 1962 · S/N 17249972
Back to AD 94-05-05 R1