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.

N285EASouth Carolina Forestry Commission · Columbia, SCBuilt 1999 · S/N 18280524N285EJCounce Mitchell K · Goodyear, AZBuilt 2011 · S/N 91845N285HGeorge Gary D · Humble, TXBuilt 1977 · S/N CE-758N285HABlacqjacq Aviation Co · Wilmington, DEBuilt 1975 · S/N TH623N285HCStiller Mark R · Anchorage, AKBuilt 1960 · S/N 18-7464N285HPGaines Robert M · Nashville, TNBuilt 1949 · S/N NAV-4-1968N285JACarroll Aviation Inc · Carroll, IABuilt 1997 · S/N 2843105N285JSFlytruckeetahoe Inc · Truckee, CABuilt 1976 · S/N 17268035N285MKPlane Nonsense Inc · Middletown, DEBuilt 2004 · S/N 2842201N285PDennin Michael E · Minden, LABuilt 1968 · S/N 28-24804N285PEBravo Leasing LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10888N285QAdams Aircraft LLC · Wilmington, DES/N 297N285RGMf Helicopters LLC · East Troy, WIBuilt 2006 · S/N 11323N285TARegistration Pending · Augusta, KSRegistration pendingBuilt 1977 · S/N 28-7716239N285TCSickinger Alan W · New Philadelphia, OHBuilt 1947 · S/N NAV-4-473N285THAtp Aircraft 2 LLC · Wilmington, DEBuilt 2018 · S/N 172S12130N285VNElizabeth City State University · Elizabeth City, NCBuilt 2019 · S/N 172S12414N285WAN285wa LLC · Carthage, NCS/N D-7889N285WY46u LLC · Anaconda, MTBuilt 2017 · S/N 3285N285ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881639N28604Quest Technical Sales & Marketing Inc · Westlake Village, CABuilt 1978 · S/N AA5B0701N2860FSullivan Stanley D · South Jordan, UTBuilt 1966 · S/N 18256960N2860KWolfe Don · Foresthill, CABuilt 1979 · S/N 18053102N2860PSchwend Brian · Forsyth, MTBuilt 1955 · S/N 18-4447N2860QLawton Metropolitan Area Airport Authority · Lawton, OKBuilt 1971 · S/N 17259860N2860RStoddard Bruce R · Tucson, AZBuilt 1967 · S/N 18258460N2860TSchmitz Nicholas S · East Lyme, CTBuilt 1972 · S/N 28-7205232N2860ZCarter Harold · Elizabethton, TNBuilt 1959 · S/N 22-6857N28610Brown Ryan O · Columbia, TNBuilt 1977 · S/N AA5B0677N28614Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843731N28618Morgan Robert J · Mojave, CABuilt 1978 · S/N AA5B0707N2861FProair LLC · Dayton, IDBuilt 1966 · S/N 18256961N2861QBlackmon Robert · San Antonio, TXBuilt 1971 · S/N 17259861N2861TDesert Sky Flight Group Inc · Tucson, AZBuilt 1972 · S/N 28R-7235147N2861WAustin And Austin Inc · Stafford, KSBuilt 1973 · S/N E-448N28622Cole Quentin P · Huntingdon Valley, PABuilt 1978 · S/N AA5B0708N28627Key City Fliers Inc · Maquoketa, IAS/N 28-7990420N2862APrecious Heir Holding Company LLC · Tucson, AZBuilt 1979 · S/N 28-7916486N2862FFoxtrot Partners LLC · West Bountiful, UTBuilt 1966 · S/N 18256962N2862PTexas Amphibians LLC · Braunfels, TXBuilt 1978 · S/N 929N2862RGuthrie Devin L · Sallisaw, OKBuilt 1967 · S/N 18258462N2862TReed Thomas F · Maize, KSS/N 28R-7235148N2862WBonanza 62w LLC · Richmond, INBuilt 1973 · S/N D-9504N2862XMathews Nancy M · Englewood, TNS/N 17700262N2862YDickson Troy S · Placerville, CABuilt 1962 · S/N 18253862N28630Flying Tiger LLC · Chesapeake, VABuilt 1978 · S/N AA5B0711N28631Perry Colin C · Petaluma, CABuilt 1978 · S/N AA5B0712N28633Fritz William J · Carnesville, GABuilt 1978 · S/N AA5B0713N28634Wolvin Michael S · N Fort Myers, FLBuilt 1978 · S/N AA5B0714N28635N28635 LLC · Harding, PABuilt 1978 · S/N AA5B0715
Back to AD 2007-04-19 R1