AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N4990JEstes Aviation LLC · Vicksburg, MSBuilt 1968 · S/N 28R-30746N4990LCc Aero Services LLC · Bullard, TXBuilt 1967 · S/N 28-4364N4990PCrux Logistics & Consulting Ltd · Las Vegas, NVBuilt 1967 · S/N 18-8564N4990UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842230N4990WKennedy Terry P · Kingman, AZBuilt 1977 · S/N 14310N4991FChouinard Christopher P · Friday Harbor, WABuilt 1966 · S/N U206-0691N4991GAlderman Melvin R · Jacksonville, FLBuilt 1972 · S/N U20601823N4991LStrickland Sterling S · Sammamish, WABuilt 1967 · S/N 28-4381N4991MOakview Homes LLC · Sullivan, MOBuilt 1978 · S/N TJ-146N4991REast Side Mosquito Abatement District · Modesto, CABuilt 1975 · S/N 18802479TN4992DSkydive Cross Keys LLC · Williamstown, NJBuilt 1958 · S/N 51092N4992JBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 28R-30748N4992LGrove City Aviation LLC · Mercer, PABuilt 1967 · S/N 28-4365N4993DPoole Jason · Quanah, TXS/N 51093N4993LEagerton Aviation LLC · Florence, SCS/N 28-4366N4993NBryant Kenneth D · Black Diamond, WABuilt 1980 · S/N 18267461N4993PHatch George R · Avon, MABuilt 1967 · S/N 18-8577N4993WHamilton Robert A · Owensboro, KYBuilt 1977 · S/N 14313N49948Stuart George G · Maceo, KYBuilt 1975 · S/N AA5A-0046N4994ARose Carey V · Colville, WABuilt 1956 · S/N 32391N4994ELaforest David C · Hudson, MIBuilt 1978 · S/N 17271688N4994FClark William R · Anchorage, AKBuilt 1967 · S/N U206-0694N4994JCrowe Justin L · Tompkinsville, KYS/N 28R-30750N4994KMenefee Jerry V · Carson City, NVBuilt 1979 · S/N P21000392N4994RCountry Air Service Inc · Hecla, SDS/N 18802481TN4994SSmith Thomas C · Norfolk, VABuilt 1970 · S/N 28R-35719N4995BStobbe Marlin L · Granada Hills, CAS/N 24-4501N4995FSkorina Frank K · Walla Walla, WABuilt 1976 · S/N 28-7725040N4995SNova Aero LLC · Ontario, ORBuilt 1970 · S/N 28R-35720N4996JLee Matthew · Magnolia, TXBuilt 1968 · S/N 28R-30752N4996LConverse Alan W · Garfield, KSBuilt 1967 · S/N 28-4369N4996SChabrian Jerry W · Daytona Beach, FLBuilt 1970 · S/N 28R-35721N4997PBrown Tyler Cooper Trustee · Anchorage, AKBuilt 1967 · S/N 18-8580N4998AWright Transport Inc · Colfax, INBuilt 1956 · S/N 32395N4998DWood Andrew A · Clifton Springs, NYBuilt 1958 · S/N 51098N4998GOdenbach Eric J · Eureka, SDBuilt 1974 · S/N 28-7425218N4998USixty Five Two Ten LLC · Oak Island, NCBuilt 1965 · S/N 21058698N4999CKipp Russell · Meadow, TXBuilt 1989 · S/N 1067MN4999DMielke Martin W · Valley City, OHBuilt 1958 · S/N 51099N4999FHarrington Jennifer L · Minneapolis, MNBuilt 1976 · S/N 28-7715091N4999LKnox Mark M · Thornton, PABuilt 1967 · S/N 28-4371N4999MStolutions LLC · Lexington Park, MDBuilt 1978 · S/N TC-2143N4999SStaples Chad V · Efland, NCBuilt 1970 · S/N 28R-35724N4999TAndy Aviation Inc · Live Oak, FLBuilt 1975 · S/N 18502729N499CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1006N499CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12510N499CRAce Tomato Company LLC · Daytona Beach, FLBuilt 1972 · S/N 27-4858N499DCConrad David J · Wausau, WIBuilt 2011 · S/N 02.1219N499DLCjrr Consulting LLC · Denver, COS/N EA-58N499DPFarrington John R · Cedar Park, TXBuilt 2010 · S/N 2001-2010
Back to AD 2007-04-19 R1