OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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.

N24673R66 And Cattle LLC · Southlake, TXBuilt 2006 · S/N 18281745N24676Goren Matthew B · Wilmette, ILBuilt 1972 · S/N M-1414N24679No Limits Aviation Inc · Hayden, IDBuilt 1973 · S/N MB-576N2467CKsg Capital LLC · Casper, WYBuilt 2000 · S/N 18280789N2467FTherkelsen Robert D · Burlington, WABuilt 1966 · S/N 18051669N2467GShort David J · Warrensburg, MOBuilt 1959 · S/N 51767N2467RSparks Eric D · Missouri Valley, IABuilt 1964 · S/N 18255567N2468BRegistered aircraftBuilt 1970 · S/N 18260274N2468CHatley Ralph A · Eagle Creek, ORBuilt 1954 · S/N 30768N2468EUrbany Mark A · Hickory, PABuilt 1978 · S/N 17271294N2468FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2000 · S/N 18280780N2468GWilliams Recycling Co Inc · Newport Coast, CABuilt 2018 · S/N E-4123N2468HStallings Cameron G · Clovis, NMBuilt 1979 · S/N 18-7909191N2468JJh Investments LLC · Henderson, NVBuilt 1996 · S/N 24-3391N2468MSmith Steven Paul · Dammeron Valley, UTBuilt 2024 · S/N 8389N2468RCruson Dale E Trustee · Ontario, ORBuilt 1964 · S/N 18255568N2468SStolen Hours LLC · Sanford, NCBuilt 2004 · S/N 1090N2468TMackie Robbie L · Murfreesboro, TNBuilt 1971 · S/N 28-7225074N2468WGodwin Gerald · Orange, TXS/N 886-2001N24693Anderson Mark D · Eureka Springs, ARBuilt 1973 · S/N M-1443N24696Lucas Charles W · Ladson, SCBuilt 1973 · S/N M-1422N24697Ritton Air Company LLC · Pittsburgh, PABuilt 2005 · S/N 172S10068N2469PMccloud James C · Mokelumne Hill, CABuilt 1955 · S/N 22-2844N2469QKepler Jason M · Wasilla, AKBuilt 1966 · S/N 18257669N2469RKrehbiel Doug W · Moscow, IDBuilt 1964 · S/N 18255569N2469TJustice Construction Corp · Friendsville, TNBuilt 1962 · S/N NAV-4-2469N2469XFraulini Michael M · Franklin Furnace, OHBuilt 1965 · S/N 18256369N246ADBialas Robert E II · Fort Worth, TXBuilt 1968 · S/N 28R-30423N246AJJensen Alan · Rock Springs, WYBuilt 2013 · S/N 82207N246AKGordon Andrew J · Paulding, OHBuilt 1999 · S/N 778N246ALAiror LLC · Lees Summit, MOBuilt 1978 · S/N E-1412N246ARMaravillas Ng LLC · Cupertino, CABuilt 2023 · S/N 18283215N246AWSullivan Stanley D · South Jordan, UTS/N 72610N246AZRegistered aircraftBuilt 1983 · S/N 28-8311025N246BGuynn Dane L · Peachtree City, GAS/N 310K0030N246BBTruman Nissley · Moberly, MOBuilt 1978 · S/N 24-0752N246BCKeystone Solutions LLC · Higley, AZS/N 18259539N246BEOn Top Aviation LLC · North Las Vegas, NVBuilt 1976 · S/N 414-0841N246BJJas Aviation LLC · East Hartford, CTBuilt 2005 · S/N 1438N246BWRc Sun Enterprises Inc · Loveland, COS/N 79-30930N246CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881002N246CCAlaska Department Of Public Safety · Anchorage, AKBuilt 1979 · S/N U20605314N246CGDickerson Realty Corp · Charlotte, NCS/N 18281485N246CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12340N246DAAdams Dennis M · Idaho Falls, IDBuilt 2021 · S/N 92131N246DTElswick Theodore · Fernley, NVS/N 71828N246DYWilson Ralph W Trustee · Mentor, OHBuilt 1996 · S/N E-3065N246EEBaldwin Alexander L · Saint Charles, MOS/N D-6797N246FC69px LLC · Suttons Bay, MIBuilt 2023 · S/N 246N246GMSky Scrapers LLC · Derry, NHBuilt 2002 · S/N 0260
Back to AD 2007-04-19 R1