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.

N4BKAccurti LLC · Deerfield Beach, FLBuilt 1967 · S/N 28-4052N4BQHann Robert Scott III · Gilbert, AZBuilt 1967 · S/N 28-4474N4BRRoberts Boyd · Celeste, TXBuilt 1973 · S/N 28R-7335423N4BSWestfall Brent J · Three Lakes, WIBuilt 1976 · S/N 1N4BWPike County Aviation Inc · Waverly, OHBuilt 1972 · S/N TC-1446N4CBDream Catcher Company LLC · Center, COBuilt 1964 · S/N 24-3607N4CKLorenzo Walker Institute Of Technology · Naples, FLBuilt 1967 · S/N 30-1645N4CWRodgers Brett Loyd · Chicago, ILBuilt 1988 · S/N 6062N4DStinson Brandon · Crowley, TXS/N JD1N4DEBruce Jerald L · Hernando, FLS/N 132N4DXHuffman Aviation & Equipment LLC · Marietta, GABuilt 1972 · S/N 210-59600N4EBDaro Norman E · Cody, WYBuilt 1972 · S/N 17260518N4ECPhantom Five Inc · Saint Louis, MOBuilt 1974 · S/N 18263038N4EQUsi Leasing LLC · Garden City, KSBuilt 1984 · S/N E-2205N4ERJet Mentors USA LLC · Littleton, COBuilt 1961 · S/N D-6869N4EWN4ew LLC · Oakland, FLBuilt 2015 · S/N 73494N4FAOgburn Benjamin R · Fernandina Beach, FLBuilt 1976 · S/N 310R0700N4FHWall Jacob · Grapevine, TXBuilt 1976 · S/N D-9973N4FJGhost River Aero LLC · Lewes, DEBuilt 1988 · S/N 0001N4FPWareham Darryl V · Mill Creek, WABuilt 1972 · S/N 18261050N4FRW J Rothwell Ranch Co · Hyannis, NEBuilt 1973 · S/N 384-73N4GAAircraft Owners And Pilots Association · Frederick, MDBuilt 1989 · S/N E-2466N4GCJenner Enterprises LLC · Partlow, VAS/N 28-21358N4GEEl Anclote LLC · Austin, TXBuilt 2010 · S/N E-3928N4GGWinson Courtenay E · Tiki Island, TXBuilt 1980 · S/N 4GGN4GKDalessandro Janet E · Park Falls, WIBuilt 1975 · S/N 310R0219N4GLWest Christina · Missouri City, TXBuilt 1973 · S/N 18262723N4GWFlannery Michael P · Saint Charles, ILBuilt 2007 · S/N 90N4HAArrington Harold M · Detroit, MIBuilt 1984 · S/N T30300283N4HESouth Florida Aerobatics LLC · West Palm Beach, FLBuilt 1976 · S/N TH-787N4HFBat Plane LLC · Memphis, TNS/N E-2421N4HHAndrews Terry · Camp Verde, AZS/N D-8422N4HRYau Jay J · Torrance, CABuilt 1973 · S/N 2N4HULevy Robert L · Echo, ORBuilt 1992 · S/N 1218N4JADiamond Aviation LLC · Tuscaloosa, ALBuilt 1994 · S/N TH-1714N4JEPallas Consulting LLC · Fort Lupton, COBuilt 1989 · S/N JLE-001N4JGCrews Rory C · Athens, ALBuilt 1972 · S/N 28-7205281N4JJJoseph John P · Hewitt, NJBuilt 2001 · S/N 1308-2000N4JKSelkirk Wings LLC · Rock Island, WABuilt 1999 · S/N 2012N4JPPreiss Aviation LLC · Wilmington, DEBuilt 2004 · S/N 88N4JXCosta James J · Tulare, CABuilt 1974 · S/N D-9642N4JYSuzuki Shoji DBA · San Jose, CABuilt 1976 · S/N 13080N4KBNichols Peter J · Soldotna, AKBuilt 1971 · S/N 18-8950N4KGYoung Randall K · Clearwater Beach, FLBuilt 1977 · S/N AA5B0454N4KJCashwell Kenneth E Jr · The Villages, FLBuilt 2018 · S/N 41108N4KKAnderson Rodney L · Pilot Rock, ORS/N 18050977N4KLRanspot Richard · Burlington, TXBuilt 1973 · S/N 18801394N4KMMuseum Of Flight Foundation · Seattle, WABuilt 1988 · S/N KM-1N4KXHorseshoe Bar Land & Livestock LLC · Gillette, WYBuilt 1977 · S/N 18052816N4KZAshleah Dna LLC · Amarillo, TXBuilt 1958 · S/N 23-1517
Back to AD 2007-04-19 R1