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.

N401AZTre Aviation Corp · Wilmington, DEBuilt 1969 · S/N 401B-0018N401BMorrison Richard L Trustee · Anchorage, AKBuilt 1978 · S/N TC-2164N401BJJohnson William L · Union City, INS/N 1N401BTKlena Bradley D · Maryville, TNS/N 401A0002N401CAGlenn Roger H · Pacifica, CABuilt 1969 · S/N 401A-0025N401CFStuewe Charles D · Chino Hills, CABuilt 1967 · S/N 401-0115N401DSalsola Logistics LLC · Douglas, WYBuilt 1977 · S/N 18503517N401DKBuford Copter Co LLC · Colorado City, TXBuilt 1988 · S/N 0929N401DRApex Aeronautical Group LLC · Jenks, OKBuilt 1980 · S/N TH-1138N401DSDelaware State University · Dover, DEBuilt 1972 · S/N 34-7250156N401DTKairos Holdings LLC · Huntsville, ALBuilt 1981 · S/N 17275165N401EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2020 · S/N 172S12535N401FLRinaldi Isaac Paul · Richardson, TXBuilt 1971 · S/N 28-7125175N401HWPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020283N401HXThree Forks Flying Club Inc · Three Forks, MTFirst renewal noticeBuilt 1974 · S/N 17263490N401KWSoutheastern Tank & Tower Inc · Lake Park, GABuilt 2020 · S/N 14394N401LALee Hunter · Colorado Springs, COBuilt 1965 · S/N 2949N401LDBrady Kevin J Trustee · Afton, OKBuilt 1977 · S/N AA5B0511N401LPMustang Sally Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9401N401LSEl Paso Aero Inc · El Paso, TXBuilt 1982 · S/N 17275784N401MPFriend Ships · Lake Charles, LABuilt 1979 · S/N P21000280N401MROk Av8r LLC · Iowa Park, TXBuilt 1967 · S/N 401-0159N401PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843444N401PJSkylens LLC · Hammond, LABuilt 1968 · S/N 27-4112N401PKJones Roderick H DBA · Thomasville, GABuilt 1998 · S/N 1438N401PSLesmeister Dean · Kindred, NDBuilt 2005 · S/N 29-0401N401RSawyers Ron S · Hayden, IDBuilt 1991 · S/N 1647N401RHTofte Shawn A · Lewis Center, OHBuilt 1999 · S/N 1986N401SBGoertzen Joshua K · Wasilla, AKBuilt 1975 · S/N TH-641N401SHBeta Fleet LLC · South Burlington, VTBuilt 2017 · S/N 1195N401SSN401ss LLC · Arvada, COBuilt 1976 · S/N 18265067N401SUWright Air Service Inc · Fairbanks, AKBuilt 1975 · S/N U20602932N401SWAnderson James Kenneth Jr · Tulsa, OKBuilt 2011 · S/N 18282301N401SXHyannis Air Service Inc · Hyannis, MAS/N 402C0447N401TCPrecision Ag Air LLC · Pendleton, INS/N 20279N401TJHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0109N401WBNew England Airlines Inc · Westerly, RIBuilt 1969 · S/N 66N401WCNakochna River Resort LLC · Willow, AKS/N 18502235N401WMMrd Aero LLC · Manheim, PABuilt 1972 · S/N 401B0219N401WWAttitude Aviators Inc · North Myrtle Beach, SCBuilt 1968 · S/N 401-0275N401ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881647N40200Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1973 · S/N 27-7304997N4020DInnovative Design Group Inc · Watkinsville, GABuilt 1999 · S/N 21063CN4020RDemers James D · Firestone, COBuilt 1967 · S/N 3240297N4020XCox Nathaniel E · Ocala, FLBuilt 1970 · S/N 5149N4020ZFinch Ernest B · Anchorage, AKBuilt 1963 · S/N 18-7972N4021Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1979 · S/N 17272149N4021BElrod Brent W · Cashion, OKBuilt 1975 · S/N 1N4021D21d LLC · West Henrietta, NYBuilt 1957 · S/N 34721N4022WAero Equities LLC · Ventura, CABuilt 2006 · S/N 172S10131
Back to AD 2007-04-19 R1