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.

N360AStrong LLC · Norcross, GABuilt 1981 · S/N E-1904N360ACAlpha Charlie LLC · Post Falls, IDBuilt 1975 · S/N 18263631N360AHMagnuson Lloyd W · Opelousas, LAS/N 12594N360AJAngle Of Attack LLC · Waynesville, OHS/N 25089N360AMAhlgren Jon E · Juneau, AKBuilt 2015 · S/N 104MN360BGregs Inc · Tiburon, CABuilt 1957 · S/N D-4910N360BBWhittier Lavoy A Bucky · Twin Falls, IDBuilt 2000 · S/N 708-320-552FBN360BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2025 · S/N 2881913N360BHRybczynski Douglas R · Chandler, AZBuilt 1995 · S/N 001N360BJCode Supplies Inc · Rossville, TNBuilt 2026 · S/N PA 206N360BSChampagne Patrick D · San Angelo, TXBuilt 1959 · S/N 18-6869N360CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281519N360CRFree Man Airshows Ltd · Lyons, COS/N 865-320-662N360DCGolike Timothy R · Anchorage, AKS/N 185-02173N360DPSiebert Mcmahon LLC · Kalispell, MTBuilt 1994 · S/N 20084N360ECdw Flyers LLC · Kinnelon, NJBuilt 2022 · S/N 18283198N360EMAg Flyers Inc · Torrington, WYBuilt 1994 · S/N 20916N360ESEdb Air Inc · Wilsonville, ORBuilt 1997 · S/N 17280010N360FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020060N360FVRegistered aircraftBuilt 2014 · S/N E-4035N360GBergmann Keith A · Lake Elmo, MNBuilt 1961 · S/N CD-306N360GJYoung Matthew · Conroe, TXBuilt 1995 · S/N 21735N360GLLaznicka Garry V · Saint Charles, MOS/N 974-320-814CSFBN360GMMcdaniel Gary D · Kansas City, MOBuilt 1996 · S/N 3492N360GTBrannigan Vanessa D · Morganton, NCBuilt 1995 · S/N 688-320-432FBN360HCMountain Air Spray Co Inc · Craig, COBuilt 1952 · S/N 18-1868N360HUParker John J · Hamilton, MTBuilt 1996 · S/N 1341N360JRahz Caleb G · Cuyahoga Falls, OHBuilt 1996 · S/N 774-320-616 FBN360JBSouthpark Partnership Ltd · Cullman, ALBuilt 1975 · S/N 18264476N360JH360jh LLC · Pompton Plains, NJBuilt 1992 · S/N 580N360JWWomack Jay A · Jackson, LABuilt 1992 · S/N 200-031N360KLCarrara Dean E · Aiken, SCS/N 1N360KMOgston Kai D · Colbert, WABuilt 2009 · S/N 001N360KSSavier Helmut Klaus · Santa Paula, CABuilt 2010 · S/N SEZ-1N360LCHeidebrink Ronald E · West Chester, OHBuilt 1993 · S/N 674-320-418FBN360LHHenney Lawrence L · Granbury, TXBuilt 1998 · S/N FB417N360LSLopez Gabriel A Trustee · El Monte, CABuilt 1996 · S/N 20190N360LULewis University · Romeoville, ILBuilt 2021 · S/N 4496522N360LWOwens Waylon D · Buckley, WABuilt 1997 · S/N 4155N360MEB L T 360 Aviation LLC · Dalhart, TXBuilt 2000 · S/N 18280849N360MFBecker James C Trustee · Whitefish Bay, WIBuilt 2003 · S/N 0036N360MHAcme Racing LLC · Overland Park, KSBuilt 1993 · S/N L-32979-36AN360MLCox Allen W Jr · Clarkton, NCBuilt 1997 · S/N 001N360MSPiggott Russ · Fresno, CABuilt 1998 · S/N 2290N360MWMission Wings International Inc · Salem, OHS/N P206-0572N360NCSap Aero Leasing LLC · Littleton, COBuilt 2024 · S/N 2376N360NEGoldrivet · Stateline, NVBuilt 1980 · S/N EA-128N360PGarman Jonathan D · Reno, NVS/N 256-24N360PBBelleville Marcel · New Port Richey, FLBuilt 2008 · S/N 522-320-260FBN360PDPrecision Aerobatics Inc DBA · Santa Margarita, CABuilt 2010 · S/N 13051
Back to AD 2007-04-19 R1