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.

N509EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12862N509FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10270N509GCN509gc LLC · Branford, CTS/N 27-7854086N509HSArmstrong Helicopters LLC · Laredo, TXBuilt 2013 · S/N 13464N509JMRegistered aircraftBuilt 1980 · S/N D10352N509LMClobro Media LLC · North Palm Beach, FLBuilt 2025 · S/N 1388N509MCCicerchi Michael P · Denver, COBuilt 2015 · S/N 57N509MMCorrales Ag Flight LLC · Othello, WABuilt 2021 · S/N 14499N509MSAhmed Asif · Canoga Park, CABuilt 1989 · S/N 509N509NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2010 · S/N 172S10950N509PTailwindsbikelyft LLC · Hannibal, MOBuilt 2000 · S/N TH-1947N509PCRich Lucas Aircraft Sales LLC · Lincoln Park, NJS/N 1487N509PGLake Stories LLC · Crosslake, MNBuilt 1977 · S/N 18503191N509RRAlten Flight LLC · Northbrook, ILBuilt 2004 · S/N 0843N509RSHalf Shell Aviation LLC · Highlands Ranch, COBuilt 1978 · S/N 414A0060N509RWRegistered aircraftBuilt 2003 · S/N 90260N509SMCompton Stephen · Kennewick, WABuilt 1974 · S/N 17263807N509SPScandinavian Aviation Academy Inc · El Cajon, CABuilt 2000 · S/N 172S8367N509SWMeise Weston · Moses Lake, WABuilt 1964 · S/N 281N509TAN509ta-Ln LLC · New Braunfels, TXBuilt 2003 · S/N 172S9404N509TCPattys Plane LLC · Tampa, FLBuilt 2009 · S/N 28028CN509UAlba Leasing Services LLC · Scottsdale, AZBuilt 2020 · S/N 109/USN50AAOgonowski Kristine Staffeldt · Wasilla, AKBuilt 1974 · S/N 1001N50ACRegistered aircraftBuilt 1994 · S/N 1200-94N50AHBrass Jeffrey A · Ackley, IABuilt 2003 · S/N 110N50AUDapp Eric M · Corvallis, ORS/N 1851368N50AWLillian Aviation LLC · Cypress, TXBuilt 1977 · S/N 18503528N50AZBenson Aviation LLC · Mehoopany, PAS/N 2093N50BDGoodrich Gilbert Joseph · Katy, TXS/N D-8175N50BGStilson Scott · Ivins, UTBuilt 1976 · S/N 14184N50BTWade William T · Fairhope, ALBuilt 1974 · S/N 28-7415164N50BXAthena Aviation LLC · Greenville, SCBuilt 2003 · S/N 10227N50CAllred & Associates Inc · Skaneateles, NYBuilt 1965 · S/N 891N50CABachmann Erik J · High Bridge, NJS/N CA001N50CBHughes Eugene F Jr · Butte, MTBuilt 1979 · S/N 414A0228N50CGDixon Jack · Casa Grande, AZS/N 18260110N50CHBaker Harold · Byrdstown, TNBuilt 1975 · S/N 18264297N50CLLopez Johnny · Henderson, NVBuilt 1976 · S/N 261-76N50CPAtkins Daniel E · Marlette, MIBuilt 1978 · S/N R18200246N50CSBoretsky Bryan F · Lolo, MTBuilt 1961 · S/N 23-1973N50CTAyers Jeffrey D · Canandaigua, NYBuilt 1978 · S/N 21062937N50CXChristmas Candy · Angel Fire, NMBuilt 1979 · S/N R18201040N50DDQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N P21000331N50DFCargille Joshua C · Kenosha, WIBuilt 1981 · S/N 122550N50DMMiller Cory L · Winnsboro, TXBuilt 1960 · S/N TD-332N50DPRenkel Christopher P · Westlake, OHS/N BROUSSARD 0001N50DTHarrell Ag Aviation LLC · Oak Grove, LABuilt 1975 · S/N 167-75N50ECPremier Wireless LLC · Kalispell, MTBuilt 1998 · S/N 29-0169N50EHSands Thomas · Columbia Falls, MTBuilt 2000 · S/N 2083N50ERFisher-Smith Jotham · Soquel, CABuilt 1978 · S/N AA5B0908
Back to AD 2007-04-19 R1