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.

N419CCHills Craig · Avon, INBuilt 1979 · S/N 28-7911268N419CDRsk Aviation LLC · Midland, MIBuilt 2005 · S/N 1377N419CMN419cm LLC · Bloomington, ILBuilt 2026 · S/N 43003N419CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12348N419CSGarza Richard · Monterey, CABuilt 2016 · S/N 18282419N419DTurner Spencer A · Modesto, CABuilt 1995 · S/N 20419N419DMNote Clayton R · Eagle Point, ORBuilt 2003 · S/N 442-2003N419DSLien Christian B · Rapid City, SDBuilt 2006 · S/N 1030-2006N419EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2019 · S/N 172S12278N419FKlenoski Brian D · Fulton, MIBuilt 2000 · S/N 22690N419FRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11446N419GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881176N419JARaw Aviation LLC · Wichita, KSBuilt 2007 · S/N 18281885N419JNWheeler Kelly · Columbia Falls, MTBuilt 2017 · S/N 419N419JRRaf LLC · Lenexa, KSBuilt 1995 · S/N 759-95N419KSClear Blue Aviation LLC · Hayden, IDBuilt 1978 · S/N 0080N419KTAlizadeh Benjamin J · Placerville, COBuilt 2008 · S/N 71895N419LJGowenmleah Jill · Lawrenceburg, TNBuilt 1977 · S/N 32-7840060N419LKSluka Christopher · San Diego, CABuilt 1978 · S/N 17271787N419MGAnderson Todd · Bondurant, IABuilt 2007 · S/N 05-503N419PASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843413N419PHTaylor Septic Services LLC · Deltona, FLBuilt 1979 · S/N 32-7940039N419RStruthers Robert J · Geneva, ILBuilt 2009 · S/N 0001N419SGilpin Nathan L · Cornelia, GAS/N 419-SN419SAStephens Kristi J · Bellingham, WABuilt 2003 · S/N 912-2003N419SBLipscomb Brian · Fulshear, TXBuilt 1992 · S/N 2811034N419SFTotal Flight Aircraft Leasing LLC · Apex, NCS/N 17262659N419STMyers Steven L · Goodyear, AZBuilt 2005 · S/N 1656N419TN419t LLC · Boise, IDBuilt 1961 · S/N CD-323N419TEEp Enterprises Inc · San Juan, PRS/N 20-0039N419TFLee General Management LLC · Olive Hill, KYBuilt 2006 · S/N E-3742N419TRAmundsen John D · Soldotna, AKBuilt 1961 · S/N CD-411N419WAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 1995 · S/N 2843001N419WPHole Jeffrey Wayne · Stockton, CABuilt 1996 · S/N 1331N419XBellamy William J · Duluth, MNBuilt 1976 · S/N 7048CN41ARobertson Roy E · Marion, IABuilt 1978 · S/N 21062798N41ABBauermeister Aida · Tw 10 SjaBuilt 1991 · S/N 3204N41ACPitts Flying Club Of Stoughton · Stoughton, WIBuilt 1979 · S/N 321GN41AEBowen Haldor S · Sandpoint, IDS/N 24-637N41AGSkyline Agrinautics Inc · Osage, IABuilt 1996 · S/N 768-96N41AMStephens Calvin · Adrian, GABuilt 1974 · S/N 17262980N41ANCampbell Ian · Miami, FLBuilt 2023 · S/N E-4153N41APRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268890N41AWWalker James A · Birmingham, ALBuilt 1966 · S/N 28-21385N41AYHunterdon Aviation Inc · Ringoes, NJBuilt 1978 · S/N 310R1416N41AZAlexander Peter · Palo Alto, CABuilt 1991 · S/N E-2628N41BBVagabond Air LLC · Dover, DES/N 6007458061228N41BEVintage Aero Collection Inc · Wilmington, DEBuilt 2007 · S/N 1690N41BJJames Robert D · Anaheim, CABuilt 1991 · S/N 10036N41BKAmerican Classic Aero LLC · Kalispell, MTBuilt 1993 · S/N 1247
Back to AD 2007-04-19 R1