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.

N32192White Charles J · Spring Lake, MIBuilt 1974 · S/N 28-7515093N32194Parker Brandt · Hillsboro, WIBuilt 1974 · S/N 28-7505036N32196Overstreet Bradley · Greenville, SCBuilt 1974 · S/N 28R-7535034N32198Garrison Resource Development LLC · Bridgeport, TXBuilt 1974 · S/N 28-7525035N3219FTop Flight Detail LLC · Middlebury, INS/N 670012N3219GWest Mi Shooting Alliance For Excellence Sfty LLC · Marne, MIBuilt 1976 · S/N 18-7709030N3219PShoot LLC · River Ridge, LAS/N 14243N3219RSotelo Aviation LLC · Naples, FLBuilt 1969 · S/N 28R-31132N3219SYogodzinkski Steve M · Amberson, PAS/N 18255719N321AAltman Mchael A · Austin, TXBuilt 1957 · S/N D-4962N321ABAmbrosini Alfred F · Connellsville, PABuilt 1979 · S/N 14523N321ALFincher William T · Chandler, AZBuilt 1976 · S/N 17268353N321AYCameron Kari L · Ashland, ORBuilt 1973 · S/N 18261756N321AZBuilders Aviation LLC · Algona, IABuilt 2003 · S/N 0508N321BValdez Aero Inc · Wilmington, DEBuilt 1957 · S/N D-4939N321BCGeorge Nathan V · Dardanelle, ARS/N 370-95N321BGItinerant Orl LLC · Columbia, SCBuilt 2005 · S/N 1311N321BHKinkel Philip J · Bow, WAS/N 5138N321BLWalls Bruce · Middletown, OHBuilt 1981 · S/N P21000792N321BSBrown Gregory N Trustee · Flagstaff, AZBuilt 1978 · S/N 18266765N321BURegistration Pending · Tavares, FLRegistration pendingBuilt 1966 · S/N 310K0184N321BWAero Marine Inc · Westland, MIBuilt 1966 · S/N D-8343N321BYStates Thane · Boise, IDBuilt 2008 · S/N 40337N321BZJakes Air Service LLC · Holt, FLBuilt 1999 · S/N 22968N321CEGreen Eggs And Ham Aero LLC · Helena, MTBuilt 1981 · S/N 421C1225N321CFTekswork Aviation LLC · London, KYBuilt 2002 · S/N 0304N321CGSuper 700 LLC · Robbinsville, NJBuilt 1979 · S/N 61P07097963341N321CHSmith James Christian · Rockport, TXBuilt 1962 · S/N 21058061N321CKFairwinds Aviation LLC · Goldsboro, NCBuilt 2004 · S/N 40.414N321CUStambaugh Scot D · Bainbridge Island, WABuilt 2004 · S/N 019N321DBDc Aviation Maintenance Inc · Bryant, ARBuilt 1978 · S/N CE-797N321DDGreene Jonathan U · Pompano Beach, FLBuilt 1980 · S/N TJ-278N321DFFranklin David A · Sealy, TXBuilt 2001 · S/N 570EN321DGAdkison Edy P · Riverside, CABuilt 1969 · S/N 21059201N321DKTwi Air LLC · Picayune, MSBuilt 1998 · S/N 18280311N321DNBrookway Aviation LLC · Brookhaven, MSBuilt 1971 · S/N 28-7125236N321DPDelta Papa LLC · Henderson, NVBuilt 1979 · S/N 32-7940032N321DRSavakinas Alan M · Clarence, NYBuilt 1979 · S/N 28-8090011N321DSYoung Winston Shannon Jr · Del Rio, TXBuilt 1958 · S/N D-5661N321DWJsj LLC · Wilmington, DEBuilt 1979 · S/N 310R1823N321EEVermont Skydiving Adventures Inc · Addison, VTBuilt 1956 · S/N 33582N321EFRengel Richard J · Tustin, CAS/N 1900N321EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2021 · S/N 172S12622N321ESQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N AA5A-0729N321FSUtah State University · Logan, UTBuilt 2004 · S/N 40.384N321GBTwisted Roots Aviation LLC · Chesterton, INBuilt 1964 · S/N 28-10413N321GDFirst Light Inc · Lafayette, LABuilt 1977 · S/N AA5B0461N321GTBennett Craig · Newbury Park, CABuilt 1994 · S/N 21158N321GW321gw LLC · Chico, CABuilt 1998 · S/N 18280209N321HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 414-0625
Back to AD 2007-04-19 R1