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.

N5657SMelton Ricky N · Luttrell, TNBuilt 1984 · S/N 8054CN5657WMacdonald Kenneth A · Willow, AKBuilt 1962 · S/N 28-822N56580Young Robert L Trustee · Ashland, OHBuilt 1973 · S/N 287325662N56581United States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502907N56584Pathfinder Air Inc · Troy, MIBuilt 1973 · S/N 28-7410012N5658BSheyman Igor · Danville, CAS/N 33658N5658KKapp Jerry · Phoenix, AZBuilt 1985 · S/N 10007CN5658UTully James W · Clarksville, TNBuilt 1969 · S/N 28-26454N5658VN5658v Aviation LLC · Huntsville, TXBuilt 1977 · S/N 28R-7737067N56591Williams Anthony S · Miramar, FLBuilt 1973 · S/N 28-7325664N56592Clw Aviation LLC · Springville, ALBuilt 1973 · S/N 28-7325665N56596Gutowski Michael H · Westfield, MABuilt 1973 · S/N 28-7405021N56598Avalos Alberto Hernandez Jr · Detroit, MIBuilt 1973 · S/N 28R-7435016N5659BAom Aircraft LLC · Wilmington, DEBuilt 1956 · S/N 33659N5659HVarnold Paul M · Pilesgrove, NJBuilt 1985 · S/N 11003CN5659JGilbert Duane A · Reno, NVBuilt 1974 · S/N 18263481N5659QKlempel Reuel David · Eltopia, WAS/N 3028N5659RBeckham Kyle J · Wasilla, AKBuilt 1985 · S/N 8062CN5659TMorgan Peter Thomas · Bellingham, WABuilt 1964 · S/N 17251559N5659WLeon James M · Frankfort, ILBuilt 1962 · S/N 28-826N565ADPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9991N565BPClark Giles R Jr · Magnolia, TXBuilt 1967 · S/N TE-405N565CHTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2026 · S/N 172S13493N565CMBackcountry Aviation LLC · North Salt Lake, UTBuilt 1968 · S/N U2061044N565EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12877N565KGGilley Jerry · Maryville, TNBuilt 1973 · S/N 18261775N565LGAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881905N565MJse Aviation LLC · Franklin, NHBuilt 1990 · S/N E-2525N565MAM & M Aviation LLC · Memphis, TNBuilt 2005 · S/N 987-2005N565MBTop Cover Aviation LLC · Tucson, AZBuilt 2009 · S/N 40749N565MCAviator Air Flight School LLC · Grand Prairie, TXBuilt 2000 · S/N 18280782N565MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.301N565NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10797N565PAero Cruz LLC · Agoura Hills, CABuilt 1999 · S/N E-3280N565QGerard Blake A · Oologah, OKS/N MK-0565N565RAN565ra LLC · Elbert, COBuilt 1977 · S/N 21062347N565RBEastern Kentucky University · Richmond, KYBuilt 2012 · S/N 4496307N565SPattarini James Martin · Houston, TXBuilt 2003 · S/N 0576N565SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 20608188N565SMMuller Scott B · Verbank, NYS/N 18267914N565SPLlp Leasing Group LLC · Lewes, DEBuilt 2000 · S/N 172S8489N565TFAir Therapy LLC · Chapel Hill, NCBuilt 2022 · S/N 2881565N565TPN565tp LLC · Vermilion, OHBuilt 1979 · S/N 28-7911311N565UEsposito John A · Rye, NHBuilt 1963 · S/N 206-0065N566Green Adam Ray · Fairbanks, AKBuilt 1979 · S/N 001N56601Hoche-Mong Michel · Campbell, CABuilt 1985 · S/N 8075CN56607Arsenault Mark E · Northampton, MABuilt 1973 · S/N 28-7405022N5660BHarlow Brett · Pryor, OKBuilt 1956 · S/N 33660N5660QIcarus Air LLC · Austin, TXBuilt 1965 · S/N 686N5660SRussek Ron · Cleburne, TXFirst renewal noticeBuilt 1966 · S/N MB-101
Back to AD 2007-04-19 R1