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.

N428EJohnson Zachary H · Anchorage, AKBuilt 2011 · S/N 3125N428EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2014 · S/N 172S11451N428FClark Robert D · Bedford, NHBuilt 1969 · S/N 28R-35201N428FFDhs Operations LLC · Wilmington, DEBuilt 2004 · S/N 17281228N428HSSchroebel John Daniel Trustee · Pleasant Hill, CABuilt 1965 · S/N 18256735N428JAJones Terry W · Houston, TXBuilt 2017 · S/N E-4104N428JGDr Rotors LLC · Mccall, IDBuilt 2003 · S/N 10168N428JPCal Aircraft LLC · Lewes, DEBuilt 2004 · S/N 40.426N428JSHoerr Stacy D · Taylor, MOBuilt 1993 · S/N 101N428KRLilly James D · Columbia, MDBuilt 1972 · S/N D-9306N428KWKangas Matthew S · Santa Cruz, CABuilt 1998 · S/N 24486N428LBMam Aviation LLC · New York, NYBuilt 2006 · S/N 18281813N428MRepanshek David J · Hertford, NCBuilt 1979 · S/N 28-8090169N428MTNby Productions · Manassas, VABuilt 2010 · S/N 18282234N428NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010014N428PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843476N428PBVander Molen William L · Hudsonville, MIBuilt 2017 · S/N 6N428RHegy Thomas R · Hartford, WIBuilt 1971 · S/N 244-HN428RBHouser Blue D · Edgemoor, SCBuilt 1963 · S/N 128N428RGGandolfo Air LLC · Watertown, CTBuilt 1973 · S/N 17262092N428RVCunningham Gary R II · Satellite Beach, FLBuilt 2014 · S/N 40303N428SGriffing Flying Service Inc · Port Clinton, OHBuilt 1980 · S/N 32-8106021N428SPStar Flight LLC · Johns Creek, GABuilt 2003 · S/N 40.283N428SXMann John Franklin Jr · Marietta, GABuilt 2014 · S/N 001N428TLight Korbin T · Midland, TXBuilt 2001 · S/N 0049N428TLJoe Rushing Plumbing Co Inc · Lubbock, TXBuilt 1967 · S/N D-8632N428TMBlue Jay Omni Bearing LLC · Fargo, NDS/N 0167N428WAPhillips Jeffry T · Ellensburg, WABuilt 1989 · S/N BIERMAN 0001N428WJGossett Corey G · Victoria, TXS/N F8L100N428WREagle Flying Club Of Embry-Riddle Aeronautical Unv · Daytona Beach, FLBuilt 2005 · S/N 172S10058N42907Albion Telephone Co · Albion, IDBuilt 1968 · S/N 18259247N4290HOwen Toy C · Anchorage, AKS/N 14-94N4290ZShearer John W · The Dalles, ORBuilt 1967 · S/N 18-8539N42911Kenney Stuart C · Atlanta, GABuilt 1968 · S/N 18259249N42912Forouzan Fardad Trustee · Poway, CAS/N 18259250N42916Nedwick Lars I · Girdwood, AKS/N 18052384N42917Afmr Inc · Dover, DEBuilt 1991 · S/N 2691N42919Tarnutzer Aviation LLC · Wayland, MIBuilt 1968 · S/N 18259253N4291HDuclos Jack B · Anchorage, AKBuilt 1949 · S/N 14-95N4291JImai Benjamin T · Silverado, CABuilt 1967 · S/N 28-22656N4291QRegistered aircraftBuilt 1976 · S/N U20603043N4291SHobart Aviation Inc · Akron, OHBuilt 1982 · S/N 28-8316036N42920Sanders Craig A · Stockton, CABuilt 2006 · S/N 5762N42927Strickland Albert L · Capitola, CABuilt 1974 · S/N 28-7415406N4292HRoss Peter W Trustee · Lufkin, TXBuilt 1948 · S/N 14-45N4292JReds Aircraft LLC · Edinburg, TXBuilt 1967 · S/N 28-22660N4292QSky Walker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17260192N4292YWalters Jason · Palm Springs, CABuilt 1983 · S/N 28-8390037N4293HHelleberg John R · Centreville, VABuilt 1978 · S/N 24-0697N4293JCoastal Virginia Aviation LLC · Chesapeake, VABuilt 1967 · S/N 28-22661
Back to AD 2007-04-19 R1